What is Wren SQL?
Wren SQL is a powerful and intuitive query language explicitly designed for use within the Wren AI platform. It provides a standardized syntax that can be used to query data from various sources, regardless of the underlying database technology.
Concepts
The SQL Statements
The question selection area displays three question candidates, each with a unique Wren SQL query.
Result Wren SQL
The results area provides a detailed breakdown of the results, including the Wren SQL statement that was used. To view this click the “View Full SQL” button.
Original SQL
In addition to the results, you can see the original SQL syntax used (e.g., BigQuery, MySQL). We also provide the option to translate from Wren SQL to the original SQL. This is only available for project where you connect directly to your data source.
Clicking the button “Show original SQL” will translate from Wren SQL to the original SQL.
You could copy the original SQL statement by click the “Copy” button.
Why is Wren SQL?
- Standardized Syntax: Wren SQL offers a consistent query language, eliminating the need to learn different SQL dialects/syntaxes for each data source.
- Simplified Querying: Wren SQL's intuitive syntax and powerful features make it easier to read complex queries.
- Seamless Integration with Wren AI: Wren SQL is designed to work seamlessly with Wren AI's other features, providing a unified experience for data analysis.
While Wren SQL is based on standard SQL syntax, it's essential to remember that Wren SQL is designed to work within the Wren AI platform. Copying and pasting Wren SQL queries directly into other databases may result in errors or unexpected behavior due to syntax incompatibility.