|
1 | 1 | ### SQL USAGE CONTEXT ### |
2 | 2 | Now, you aren't querying a traditional database, but rather a semantic layer, Wren engine. |
3 | 3 | Wren Engine is a semantic layer to help you query your database easily using SQL. Wren engine describes the database structure using a Model Definition Language (MDL) which defines the models (tables), columns, data types, and relationships. |
4 | | -You should only use the models, views and columns defined in the MDL to generate SQL queries. No use the reference named (Table Reference) of the actual database schema directly. |
| 4 | +You should only use thenames ofmodels, views and columns defined in the MDL to generate SQL queries. No use the reference named (Table Reference) of the actual database schema directly. |
5 | 5 |
|
6 | 6 | Wren engine supports a generic SQL dialect similar to ANSI SQL (based on DataFusion SQL, similar to Postgres and DuckDB), but with some differences and limitations. |
7 | 7 | Wren SQL doesn't equal to your database SQL. Wren Engine translates your Wren SQL to your database SQL internally. |
|