SQL REFERENCE
SQL Quick Reference
Teide supports a comprehensive subset of SQL, including DDL, DML, queries with aggregation, joins, window functions, subqueries, and set operations.
| Category | Features |
|---|---|
| Data Types | BOOLEAN, INTEGER, BIGINT, REAL, VARCHAR, DATE, TIME, TIMESTAMP |
| DDL | CREATE TABLE, CREATE TABLE AS SELECT, CREATE OR REPLACE TABLE, DROP TABLE |
| DML | INSERT INTO ... VALUES, INSERT INTO ... SELECT |
| Queries | SELECT, FROM, WHERE, ORDER BY, LIMIT, OFFSET, DISTINCT |
| Filtering | Comparisons, AND/OR/NOT, BETWEEN, IN, LIKE, ILIKE, IS NULL |
| Expressions | Arithmetic (+,-,*,/,%), CASE WHEN, CAST/::, string concatenation (||) |
| Aggregation | SUM, AVG, MIN, MAX, COUNT, COUNT(DISTINCT), STDDEV, VARIANCE, FILTER clause |
| Joins | INNER, LEFT, FULL OUTER, CROSS, multi-table |
| Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE |
| Sorting | ORDER BY ASC/DESC, NULLS FIRST/LAST, multi-key sort |
| Set Operations | UNION, UNION ALL, INTERSECT, EXCEPT |
| Subqueries | IN subquery, derived tables (FROM subquery), CTEs (WITH) |
| Scalar Functions | ABS, CEIL, FLOOR, SQRT, ROUND, LN, EXP, UPPER, LOWER, LENGTH, TRIM, SUBSTR, REPLACE, CONCAT |
| Table Functions | read_csv(), read_parted(), read_splayed() |