SQL¶

SQL queries are the most powerful way to access data stored in a base. SeaTable supports SELECT, INSERT, UPDATE, and DELETE statements. SQL is not a standalone interface but is used through the Python or JavaScript API via base.query():

results = base.query("SELECT * FROM Table1 LIMIT 100")

const results = await base.query("SELECT * FROM Table1 LIMIT 100");

SQL syntax is case insensitive. We use upper-cased keywords for readability.