What's new in SQL Server Language Extensions?
Applies to: SQL Server 2019 (15.x)
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
The new capabilities for Language Extension in SQL Server 2019 can be found below. For more information about all of the features in this release, see What's New in SQL Server 2019 and Release Notes for SQL Server 2019.
New 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.
New 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.
- Supported Java data types.
- CREATE EXTERNAL LANGUAGE for registering external language (for example, Java) in SQL Server.
- Microsoft Extensibility SDK for Java.
- 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 Java from SQL Server.
- Java language extension 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.
New 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?
- Install SQL Server Language Extensions on Windows or on Linux.