https://sqlines.com/sql-server-to-postgresql/outer_apply
OUTER APPLY - SQL Server to PostgreSQL Migration - SQLines Tools
SQL Server OUTER APPLY clause allows you to perform a correlated outer join (lateral join) often using a table-valued function or subquery. Correlated means...
sql server to postgresqlouterapplymigrationtools
https://sqlines.com/sql-server-to-postgresql/with_rollup
WITH ROLLUP in GROUP BY - SQL Server to PostgreSQL Migration - SQLines Tools
In SQL Server, you can use the legacy WITH ROLLUP clause in the GROUP BY clause of a SELECT statement. In PostgreSQL, you can use the GROUP BY ROLLUP clause,...
sql server to postgresqlgroup by