item_version_detail (view)

16 rows where likes = 0 and tags contains "safetensors"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: _commit_at, _commit_hash, _commit, tags, _commit_at (date), tags (array), _changed_columns (array)

CREATE VIEW item_version_detail AS select
  commits.commit_at as _commit_at,
  commits.hash as _commit_hash,
  item_version.*,
  (
    select json_group_array(name) from columns
    where id in (
      select column from item_changed
      where item_version = item_version._id
    )
) as _changed_columns
from item_version
  join commits on commits.id = item_version._commit;