Understanding different SQL Interfaces

On Hive, or Impala or Pesto you can access data by..

b
..Query Utilities/SQL Editors like Data Grip, SQuirrel, DBeaver..

 

c
..or Data Analytic Software like Tableau

d
being connected with ODBC (Tableau) or JDBC(SQuirrel)