saved_queries
1 row
This data as json, CSV (advanced)
| name ▼ | sql | author_id |
|---|---|---|
| Walking & Running distance | select substr(startDate, 0, 5), sum(value) from rDistanceWalkingRunning group by 1 | jer |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [saved_queries] ( [name] TEXT PRIMARY KEY, [sql] TEXT, [author_id] TEXT );