I actually implemented something like this a few years ago on top of Postgres for the CKAN Data Portal Software. Check out the docs at https://docs.ckan.org/en/

I actually implemented something like this a few years ago on top of Postgres for the CKAN Data Portal Software. Check out the docs at https://docs.ckan.org/en/2.8/maintaining/datastore.html#ckanext.datastore.logic.action.datastore_search_sql https://docs.ckan.org/en/2.8/maintaining/datastore.html#ckan.... CKAN is used by data.gov, data.gov.uk and many other governments to publish open data.