Clauses

We currently support the following SQL query statements and clauses with BodoSQL, and are continuously adding support towards completeness. Note that BodoSQL ignores casing of keywords, and column and table names, except for the final output column name. Therefore, select a from table1 is treated the same as SELECT A FROM Table1, except for the names of the final output columns (a vs A).

• Aliasing
• CASE
• CAST
• GREATEST
• GROUP BY
• HAVING
• INDEX
• ::
• INTERSECT
• JOIN
• LEAST
• LIKE
• LIMIT
• NATURAL JOIN
• NOT BETWEEN
• NOT IN
• ORDER BY
• PIVOT
• QUALIFY
• SELECT
• SELECT DISTINCT