Does the Firebird ODBC driver support setting SQL Dialect at runtime?

No. Currently, SQL dialect can be set for the connection, but it's not a statement-level property.