SQL Reference
This section provides a comprehensive reference for SQL support in Spice.ai, including syntax, data types, operators, functions, and system features. The reference is organized by topic for ease of navigation.
Table of Contents​
SELECT Syntax​
- WITH Clause
- SELECT Clause
- FROM Clause
- WHERE Clause
- JOIN Clause
- GROUP BY Clause
- HAVING Clause
- UNION Clause
- ORDER BY Clause
- LIMIT Clause
- EXCLUDE and EXCEPT Clause
Subqueries​
- Subquery Operators
- SELECT Clause Subqueries
- FROM Clause Subqueries
- WHERE Clause Subqueries
- HAVING Clause Subqueries
- Subquery Categories
EXPLAIN​
Information Schema​
Operators and Literals​
Scalar Functions​
- Math Functions
- Conditional Functions
- String Functions
- Binary String Functions
- Regular Expression Functions
- Time and Date Functions
- Array Functions
- Struct Functions
- Map Functions
- Hashing Functions
- Union Functions
- Other Functions
Search​
Prepared Statements​
Refer to each section for detailed syntax, supported features, and examples.