Skip to content

Instantly share code, notes, and snippets.

@simonw
Created May 12, 2023 16:57
Show Gist options
  • Save simonw/b71c57ae3b21c85bcb7b23a9af4a2000 to your computer and use it in GitHub Desktop.
Save simonw/b71c57ae3b21c85bcb7b23a9af4a2000 to your computer and use it in GitHub Desktop.
create view baseline as select
_key,
spec,
'' || json_extract(status, '$.is_baseline') as is_baseline,
json_extract(status, '$.since') as baseline_since,
json_extract(status, '$.support.chrome') as baseline_chrome,
json_extract(status, '$.support.edge') as baseline_edge,
json_extract(status, '$.support.firefox') as baseline_firefox,
json_extract(status, '$.support.safari') as baseline_safari,
compat_features,
caniuse,
usage_stats,
status
from
[index]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment