generated_columns

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

1 row

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

Link rowid ▼ body id consideration
1 1 { "number": 1, "string": "This is a string" } 1 This is a string

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE generated_columns (
    body TEXT,
    id INT GENERATED ALWAYS AS (json_extract(body, '$.number')) STORED,
    consideration INT GENERATED ALWAYS AS (json_extract(body, '$.string')) STORED
);