SQL Queries¶

Use SQL to query a base. This is the most powerful way to access data. For the full SQL syntax reference, see the SQL Reference.

query

await base.query(sql);

Backticks for special names

Escape table or column names that contain spaces, special characters, or are SQL function names with backticks: SELECT * FROM `My Table`

Output Array of row objects

Example: SELECT all

const data = await base.query('SELECT * FROM Bill');

Example: WHERE

const data = await base.query('SELECT name, price FROM Bill WHERE year = 2021');

Example: ORDER BY

const data = await base.query('SELECT name, price, year FROM Bill ORDER BY year');

Example: GROUP BY

const data = await base.query('SELECT name, SUM(price) FROM Bill GROUP BY name');
// Returns: [{'SUM(price)': 600, 'name': 'Bob'}, ...]

Example: DISTINCT

const data = await base.query('SELECT DISTINCT name FROM Bill');