Parametrize queries

Insert data from sheet into your queries with parametrized queries.

Parametrized reference

You can reference sheet data in SQL. Use {{}} notation for references. You can only reference single cells at a time.

SELECT * FROM {{A1}} WHERE salary > {{A4}}

Note in the following example where the query output changes based on what table is selected in cell B1.

Parametrize a reference from another sheet

select abc from def where ghi="{{'Sheet_name'!H3}}"