DBSQL supports the following types of query caching which can help with the query performance -
1). Databricks SQL UI caching
2). Query results caching
3). Delta caching
Please check here for details -
https://docs.databricks.com/sql/admin/query-caching.html#query-caching