Description

#547 added SQLite support through the aaemnnosttv/wp-sqlite-db drop-in database plugin which rewrites MySQL queries to SQLite queries. Unfortunately, many MySQL queries are unsupported at the moment and a lot of WordPress unit tests fail.

Let's find a way to support all the MySQL queries that can be translated to SQLite.

cc @aristath @felixarntz