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

4 rows

View and edit SQL

content upper_content
hello HELLO
world WORLD
   
{"column": "content", "table": "simple_view", "database": "fixtures", "config": {"depth": "database"}} {"column": "upper_content", "table": "simple_view", "database": "fixtures", "config": {"depth": "database"}}

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW simple_view AS
    SELECT content, upper(content) AS upper_content FROM simple_primary_key;