That is the wonderful thing about the Lakehouse, data is in open formats with open API's. Please see these options for querying via Go, Node.js, Python as well as via API

https://www.databricks.com/blog/2023/03/07/databricks-sql-statement-execution-api-announcing-public-...

https://www.databricks.com/blog/2022/06/29/connect-from-anywhere-to-databricks-sql.html

As you said, you can also download and install the ODBC driver to connect from different applications:

https://docs.databricks.com/integrations/jdbc-odbc-bi.html

Databricks SQL Warehouses can scale vertically for data throughput as well as horizontally for concurrency, please review your concurrency requirements with your Databricks account team for specific guidance.