Relational operators (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
A relational operator is a syntax element that can accept one or more named or unnamed input parameters and returns a result set. Relational operators are used as table source in a DML statement.
SQL Server implements the following relational operators:
- GENERATE_SERIES (Transact-SQL)
- OPENDATASOURCE (Transact-SQL)
- OPENQUERY (Transact-SQL)
- OPENROWSET (Transact-SQL)
- OPENXML (Transact-SQL)
- OPENJSON (Transact-SQL)
- PREDICT (Transact-SQL)
- STRING_SPLIT (Transact-SQL)
Use
Use a relational operator like a table-valued function in a query or T-SQL statement.