Can my DB?

Procedural / Programmability

Stored procedures, functions, triggers, cursors, and dynamic SQL.

0 features
but not in
Stored Procedures
Named procedural code blocks stored in the database that can be invoked by name, with support for control flow, variables, and transaction management.
stored proceduresprocprocedureCREATE PROCEDURE
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Table-Valued Functions (TVFs)
Functions that return a result set (table) that can be used in the FROM clause of a query.
TVFtable functionRETURNS TABLESETOFpipelined functiontable-valued functioninline TVF
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Triggers
Stored procedures that automatically execute in response to INSERT, UPDATE, or DELETE operations on a table.
triggerCREATE TRIGGERBEFORE triggerAFTER triggerINSTEAD OF triggerrow triggerstatement trigger
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
Two-Phase Commit (2PC)
A distributed transaction protocol ensuring all participating databases commit or roll back atomically across multiple resources.
2PCtwo-phase commitPREPARE TRANSACTIONXAdistributed transactionXA STARTPREPARE TRANSACTION
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery
User-Defined Functions (UDFs)
Custom scalar functions defined by the user in SQL or a procedural language, callable in queries.
UDFCREATE FUNCTIONscalar functionuser-defined functioncustom function
Postgres MySQL MariaDB Oracle SQL Server SQLite Redshift DB2 Snowflake BigQuery