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
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
- 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. Learn more: 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.
For details on how to install, configure, and use the extension, see What is C# Language Extension?
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for