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