From this:
https://community.dremio.com/t/is-parameterized-sql-not-supported-by-dremio/4650/2
It appears that as of now the ODBC driver does not support parameterised queries which would likely explain this.
The current driver is 0.9.1 from July 2022 so approx ~2.5 years since any updates.