baseline-view.sql

May 12, 2023 · View on GitHub

create view baseline as select _key, spec, '' || json_extract(status, '.isbaseline)asisbaseline,jsonextract(status,.is_baseline') as is_baseline, json_extract(status, '.since') as baseline_since, json_extract(status, '.support.chrome)asbaselinechrome,jsonextract(status,.support.chrome') as baseline_chrome, json_extract(status, '.support.edge') as baseline_edge, json_extract(status, '.support.firefox)asbaselinefirefox,jsonextract(status,.support.firefox') as baseline_firefox, json_extract(status, '.support.safari') as baseline_safari, compat_features, caniuse, usage_stats, status from [index]