YugabyteDB Supports User Defined Functions (UDFs) Like PostgreSQL
YugabyteDB supports User Defined Functions (UDFs) like PostgreSQL, enabling complex processing logic directly within SQL queries.
YugabyteDB has always supported User Defined Functions (UDFs) in its PostgreSQL compatible API because... it is PostgreSQL compatible. I've been working with Oracle database since version 7.1 and UDFs, as PL/SQL function were already there (as far as I remember). But it was like an anti-pattern when used from a SQL query because, running in another engine, context switches between SQL and PL/SQL was killing the performance. In Oracle 12c came the possibility to run them in the SQL engine (Pragma UDF) and in Oracle 19c came the real in-lining of UDFs with SQL Macros. With those, UDFs can finall...