The CASE statement in SQL is a way of creating branches or alternatives ... The simple form compares a single expression to a list of values, while the searched form evaluates a series of boolean ...

SIGNAL and RESIGNAL are SQL statements that allow you to raise and propagate user-defined errors or conditions. You can use them to implement custom logic, validation, or business rules in your ...

In SQL we support non-standard clause called ON CONFLICT / OR. It is not a separate clause which can appear in INSERT/UPDATE statements or as a column option in CREATE TABLE statements. See examples ...