Add mysql support

[jmcopeland]

Any clue what it might take to add mysql support?

[JaredStufftGD]

Hi Justin, sorry for the late response. Django by default uses the mysqlclient to connect to MySQL databases. This library doesn't have an explicit mogrify command (which the psycopg2 package for Postgres does have). I checked the execute method for the cursor object in mysqlclient and it looks like they compile the query string there: https://github.com/PyMySQL/mysqlclient/blob/main/MySQLdb/cursors.py

So probably would need to test the individual steps that they're doing in the execute method to combine the query template and the args, see if that generates the usable SQL we're looking for, and then creating a function to do the compile and add it as a backend to django-sql-compiler.

[jmcopeland]

I found this open pull request to add mogrify support to mysqlclient PyMySQL/mysqlclient#477