unable to add pinot as driver/datasource for Jetbrains tools (IntelliJ or Datagrip)

Due to various issues with the JDBC driver, I was unable to connect Jetbrains GUIs to Apache Pinot using the JDBC Driver. The encountered issues were mostly caused by unnecessary use of `SQLFeatureNotSupportedException` for metadata introspection where returning actual values would be more apprpriate.

Start with the Apache Pinot JDBC driver and its metadata introspection entry points, focusing on uses of SQLFeatureNotSupportedException. Reproduce the connection attempt from IntelliJ or DataGrip, then identify which metadata calls fail and verify that the driver returns usable metadata so both JetBrains tools can connect successfully.

Written by the indexing model from the issue text.