📄️ AT
The SELECT statement can include an AT clause that allows you to query previous versions of your data by a specific snapshot ID or timestamp.
📄️ JOIN
A join allows you to combine columns from two or more tables into a single result set. Databend supports the following join types:
📄️ JSON PATH
Databend supports Semi-structured data type and allow retrieving the inner elements by JSON path operators:
📄️ SELECT
Retrieves data from a table.
📄️ WITH
Databend supports common table expressions (CTEs) and allows you to use a WITH clause to define one or multiple named temporary result sets that are used by the query that follows. The "temporary" means that the result sets will be not permanently stored anywhere in the database schema. They act as temporary views that are only available to the query that follows.