For a while, we can use UDF instead of parameterized queries.
For example
CREATE FUNCTION IF NOT EXISTS `constants.get_parameter_a`() AS (100);
SELECT * FROM `x.x` WHERE a = `constants.get_parameter_a`();
You can replace the constants.get_parameter_a before executing the query.