I don't believe Postgres has this natively, but an alternative to OP is Citus, a Postgres extension which allows this kind of syntax. https://www.citusdata.com

I don't believe Postgres has this natively, but an alternative to OP is Citus, a Postgres extension which allows this kind of syntax. https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-postgres/ https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-... EDIT: per another comment, OP is a fork of Citus Columnar!