AI functions in SQL
AI functions in SQL (Snowflake Cortex, BigQuery, Databricks, Fabric, Apache Doris AI) call LLMs from SQL to classify, extract, summarize, and translate text per row, with token-based costs and query-engine optimizations.
Database trigger
A database trigger, or SQL trigger, is a stored program a database executes automatically when an event such as an INSERT, UPDATE, or DELETE occurs on a table.
PL/SQL
PL/SQL (Procedural Language/Structured Query Language) is Oracle's procedural extension to SQL, released in 1991, letting developers declare variables, control program flow, and trap runtime errors.
Transact-SQL
Transact-SQL, or T-SQL, is Microsoft's and Sybase's proprietary extension of SQL, developed by Sybase and carried into Microsoft SQL Server from 1989, adding variables, control-of-flow keywords, transactions, and stored procedures to standard SQL.