table_with_compound_pk
3 rows where pk2 = 1 sorted by pk1
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [table_with_compound_pk] ( [pk1] INTEGER, [pk2] INTEGER, [name] TEXT, PRIMARY KEY ([pk1], [pk2]) );