Open sgielen opened 8 months ago
Since this is a INSERT INTO (...) SELECT
query which isn't relevant for the schema, it would also be an acceptable workaround if we could simply allow errors in unsupported queries (#1756) or perhaps allowing sqlc generate
to ignore the statement completely, e.g. with an -- sqlc:ignore
line above it or perhaps by excluding the file altogether in sqlc.yaml.
Filed #3130 to allow for a work-around while this is being investigated further.
Version
1.25.0
What happened?
A migrations file using the MySQL
JSON_TABLE
function cannot be parsed by sqlc. (Documentation for MySQL, MariaDB)Relevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/0bed956ccb54908516d6a6f70813e4cf1182bb978b548689034de7813eb7efce
What operating system are you using?
macOS
What database engines are you using?
MySQL
What type of code are you generating?
Go