You could use PostgreSQL Foreign data wrappers[1] and leverage PostgREST for a SQL Server schema. tds_fdw[2] works pretty well for this(I've used it in a proje

You could use PostgreSQL Foreign data wrappers[1] and leverage PostgREST for a SQL Server schema. tds_fdw[2] works pretty well for this(I've used it in a project related to open data). Basically, you'd have to map mssql tables to pg foreign tables[3] defined on a pg schema. Lastly expose this pg schema through PostgREST. [1]: https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://wiki.postgresql.org/wiki/Foreign_data_wrappers [2]: https://github.com/tds-fdw/tds_fdw/ https://github.com/tds-fdw/tds_fdw/ [3]: https://github.com/tds-fdw/tds_fdw/blob/master/ForeignTableCreation.md#example https://github.com/tds-fdw/tds_fdw/blob/master/ForeignTableC...