SQL Editor

The SQL Editor lets you run any DuckDB-compatible query against your project tables and immediately view the results as a
table, chart, or map layer.

Key capabilities:

• Full DuckDB SQL syntax, including CTEs, window functions, and joins
• Spatial functions via the DuckDB spatial extension (ST_Distance, ST_Within, ST_Buffer, etc.)
• H3 indexing functions (h3_latlng_to_cell, h3_cell_to_boundary, etc.)
• Query history and saved queries
• Autocomplete for tables, columns, and functions
• Cancel long-running queries at any time

Typical steps:

1. Open the SQL Editor panel.
2. Write your query.
3. Press Run (or Cmd/Ctrl + Enter).
4. Inspect the result table below the editor.
5. Save the result as a new table, export it, or turn it into a map layer.