Skip to main content

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.

w_ai_sql.png

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.

view_sql.gif

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.

show_original_sql

note

Clicking the button “Show original SQL” will translate from Wren SQL to the original SQL.

show_original_bq_sql

note

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.
Important Note: Wren SQL is Exclusive to Wren AI

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.