@arkiboys - Thanks for the question and using MS Q&A platform.
You can use a Databricks SQL Warehouse and connect to it via ODBC (Configure the Databricks ODBC and JDBC drivers - Azure Databricks | Microsoft Learn) or call the SQL Statement Execution REST API (Run SQL statements on Databricks SQL warehouses with the Databricks SQL Statement Execution REST API - Azure Databricks - Databricks SQL | Microsoft Learn).
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.