title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

ms.custom

monikerRange

What's new in SQL Server Language Extensions?

Learn about what's new in SQL Server Language Extensions that expands, extends, and deepens the integration between external languages and the data platform.

rwestMSFT

randolphwest

04/29/2024

sql

language-extensions

conceptual

intro-whats-new

>=sql-server-ver15 || >=sql-server-linux-ver15

What's new in SQL Server Language Extensions?

[!INCLUDE sqlserver2019-and-later]

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 [!INCLUDE sssql19-md] and later versions are described in this article. For more information, review the following articles.

[What's new in [!INCLUDE sql-server-2019]](../sql-server/what-s-new-in-sql-server-2019.md)
[What's new in [!INCLUDE sql-server-2022]](../sql-server/what-s-new-in-sql-server-2022.md)
[[!INCLUDE SQL Server 2019] release notes](../sql-server/sql-server-2019-release-notes.md)
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