SQL: Consider replacing exception with empty result sets in JDBC metadata

[costin]

Currently the JdbcDatabaseMetaData throws a SQLFeatureNotSupportedException for methods that are unsupported (such as getVersionColumns).
However these methods also return a ResultSet hence it is worth investigating whether returning an empty result set (with the appropriate column) is a better alternative as some clients might be able to handle them better (potentially eliminating existing warning inside the UI or logs).

[elasticmachine]

Pinging @elastic/es-search

[costin]

After running some tests I'm raising the importance of this to a bug as it improves the behavior of certain JDBC consumers significantly.