In case others find this post in the future you need to use a ? mark for MySql (instead of $1 or @parameter_name) queries with parameters.
If you want more functionality we offer this well supported plugin: SQL Database Connector Pro Plugin | Bubble
Documentation here: Introduction - SQL Database Connector Pro