Use Cases

Compared to Excel visual analysis, the addition of SQL language makes some complex data scenarios simpler.

Data Integration (Multi-table Join)

If you are more familiar with SQL, it will be more convenient to implement multi-table joins rather than using VLOOKUP.

Data Manipulation

Based on SQL functions, it is more convenient to manipulate data.

Parsing JSON

SELECT json_extract (extra, 'gender') AS gender
-- or
SELECT extra -> 'gender' AS gender

Regular Expression Matching

regexp_replace('hello', '[e]', '-')
-- h-llo

SQL Analysis is developed based on DuckDB Wasm. For more function support, please refer to DuckDB Functions.

SQL Practice Playground

For SQL beginners, you can use SQL Analysis to practice SQL. Based directly on Excel data, you don't need to spend more time preparing the database and running environment.