full_subdiagrams_transitive (view)
1 row where subshape = "tower"
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW "full_subdiagrams_transitive" AS with recursive t as ( select subshape, shape from full_subdiagrams union select full_subdiagrams.subshape, t.shape from full_subdiagrams join t where full_subdiagrams.shape == t.subshape ) select * from t;