Skip to main content

DataFrames using SQL

SQL Frames allows composing complex DataFrames declaratively using familiar SQL constructs. As an in-memory analytics engine running in the browser, SQL Frames is implemented using TypeScript. All the various SQL clauses have corresponding static API accessible via the SQL class.

Below is an example of how the SQL API is used to create a DataFrame. Rest of the documentation covers these API in depth. In this documentation, every DataFrame is displayed followed by the corresponding auto-generated SQL (this option can be toggled here). This further helps to understand how the API transpiles to the various SQL clauses.


To try out the generated SQLs against an actual database, you can download the Datasets and create the appropriate tables.