It's likely that you are running into issues during SQL dialect translation. You need to pass UseNativeQuery=1 in your ODBC connection string. See Databricks ODBC docs
UseNativeQuery=1