sp_execute_external_script

Run a script in the extensibility framework.

The script must be written in (as of SQL Server 2017) R or Python. SQL Server Preview 2019 additionally seems to support also Java.

If using R, generally, the output of sp_execute_external_script is limited to a single data frame.

Howerver, additional scalars can be returned using the @params paremeter.