We (bit.io) use SQLGlot and love it! We use it in our open-source sqlite->postgres tool, pgsqlite:https://github.com/bitdotioinc/pgsqlite, and in our general SQL parser where we can translate between dialects (https://docs.bit.io/docs/query-translation):

  #!translate:sqlite
  select \* from [foo]

That will translate the given sql (which is in SQLite syntax) into PostgreSQL SQL and then run that query.

Also, Toby & team may be the most responsive open-source maintainers I've ever seen. Open issues are often closed within a day. It's awesome.