What's new in SQL Server Language Extensions?

Applies to: SQL Server 2019 (15.x) and later versions

Language Extension capabilities are added to SQL Server in each release as we continue to expand, extend, and deepen the integration between external languages and the data platform.

SQL Server 2019 and later versions

The new capabilities for SQL Server Language Extensions in SQL Server 2019 (15.x) and later versions are described in this article. For more information, review the following articles.

• What's new in SQL Server 2019 (15.x)
• What's new in SQL Server 2022 (16.x)
• SQL Server 2019 (15.x) release notes
• SQL Server 2022 release notes

Language extensions available

Python and R language extensions

• A Python custom runtime is available with Language Extensions. For more information, see how to Install a Python custom runtime on Windows or Install a Python custom runtime on Linux.

• An R custom runtime is available with Language Extensions. For more information, see how to Install a R custom runtime on Windows or Install a R custom runtime on Linux.

Java language extension

• A Java language extension is available, supported by the SQL Server Language Extensions extensibility framework.

• The default Java Runtime on Windows and Linux is Open Zulu JRE and is included with the SQL Server Language Extensions installation on Windows and SQL Server Language Extensions installation on Linux.

• Java and SQL Server supported data types.

• CREATE EXTERNAL LANGUAGE for registering external language (for example, Java) in SQL Server.

• Microsoft Extensibility SDK for Java for SQL Server.

• On Windows and Linux, Java code can be accessed in an external library using the CREATE EXTERNAL LIBRARY (Transact-SQL) statement. For more information, see How to call the Java runtime in SQL Server Language Extensions.

• SQL Server Language Extensions on Windows and Linux. You can make compiled Java code available to SQL Server by assigning permissions and setting the path. Client apps with access SQL Server can use data and run your code by calling sp_execute_external_script, the same procedure used for R and Python integration on SQL Server Machine Learning Services.

C# language extension

• A C# language extension is available, supported by the SQL Server Language Extensions extensibility framework.

• Install SQL Server .NET Language Extension on Windows.

• C# and SQL Server supported data types.

• CREATE EXTERNAL LANGUAGE for registering external language (for example, C#) in SQL Server.

• Microsoft Extensibility SDK for C# for SQL Server.

• On Windows, C# code can be accessed in an external library using the CREATE EXTERNAL LIBRARY (Transact-SQL) statement. For more information, see How to call the .NET runtime in SQL Server Language Extensions.

• SQL Server Language Extensions on Windows. Client apps with access SQL Server can use data and run your code by calling sp_execute_external_script, the same procedure used for Java, as well as R and Python integration on SQL Server Machine Learning Services.

Related content

• Install SQL Server Java Language Extension on Windows
• Install SQL Server Java Language Extension on Linux