generated_columns
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
1 row
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
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 );