I don't think its possible unless the results written into a table and its being used in the queries across the client. Pls refer to this https://docs.databricks.com/en/sql/user/queries/query-caching.html
SQL migration tips and training from legacy databases into databricks SQL warehouse to support Delta lake migrated Databricks catalogues. Limitations, experience and challenges.
Hope this link will help. You can use cell command within a notebook to unzip (assuming you have the path access where do you want to unzip the file).https://stackoverflow.com/questions/74196011/databricks-reading-from-a-zip-file
