home / photos

Menu
  • ripgrep search
  • Dashboards

saved_queries

1 row

✎ View and edit SQL

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

CSV options:

CREATE TABLE [saved_queries] (
   [name] TEXT PRIMARY KEY,
   [sql] TEXT,
   [author_id] TEXT
);
Powered by Datasette · Queries took 6.708ms