CONVERT() queries fail with error

The Jetpack CRM plugin uses CONVERT() queries, which are valid MySQL queries, but they fail in the Playground.

The example query that works on MySQL, but not on SQLite, looks as follows:

SELECT CONVERT('Customer' USING utf8mb4) COLLATE utf8mb4_bin;

Translate MySQL CONVERT() expressions to SQLite

Also found a Python sql-transpilation project: https://github.com/tobymao/sqlglot (should also be handling mysql2sqlite direction)

I wonder if it can be used e.g. for testing

Navigation Menu