Is it possible to write a stored procedure for SQL in another language (eg C++)?

Question

SQL

In MySQL, in the description of the header of a stored procedure there is a LANGUAGE SQL item, in the book by Kuznetsov M.V (MySQL 5.0) it is written that it is expected to be able to support the PHP syntax for writing procedures. But PHP doesn't interest me.
Also, I heard that it is possible to write a procedure in compiled languages ​​such as C, compile, and use the SQL database. I didn’t find anything on the Internet, is it possible to write a store in C ++ and use it in MySQL (or other DBMS)?

Answer 1

As far as I know, a stored procedure cannot be written directly in SQL.
You can write UDFs (user defined functions) that can be called from SQL queries.
https://dev.mysql.com/doc/refman/8.0/en/adding-udf.html