AFAIK its rather far off from Postgres syntax, or certainly has a lot of different functions at least. It may be a while, given cultural differences.
I'm rather surprised they're not using something like knex here, which would make psql + mssql + mysql etc available fairly out of the box, but I'm sure there's a good technical reason they're not.