Let SQLDialect decide whether to apply hints on virtual tables
Description
Currently, JDBCDataStore does not add select-hints to queries on virtual tables. This makes sense for some SQLDialects, but not for all.
We should add a new method applyHintsOnVirtualTables() to the SQLDialect class that allows the concrete SQLDialect to control whether hints are added to queries on virtual tables. The default implementation of applyHintsOnVirtualTables() should return false to keep the current default behavior.
Currently,
JDBCDataStoredoes not add select-hints to queries on virtual tables. This makes sense for someSQLDialects, but not for all.We should add a new method
applyHintsOnVirtualTables()to theSQLDialectclass that allows the concreteSQLDialectto control whether hints are added to queries on virtual tables. The default implementation ofapplyHintsOnVirtualTables()should returnfalseto keep the current default behavior.