It does not. This means that you will have to update many SQL queries to support the PostgreSQL syntax.
Check the qa-include/db directory and you'll see many files that will need to be updated. Some queries will work out of the box but many others, specially the ones with specific MySQL syntax, will not. Also bear in mind you'll have to update the installation queries too as well as any plugin that queries the database directly.