Running Query over SPICE Datasets

I wanted to know if there is a way to run SQL queries over the SPICE Dataset for adhoc analysis which get refreshed occasionally. Any APIs to solve the problem is also fine.

Thanks in advance

Can you explain more of what you are trying to do?

Are you trying to run queries on information of SPICE dataset (size etc.) or run a query on the data in the dataset?

I am trying to run queries over the data in the dataset.

There is no way to run a custom sql query on the dataset itself.

Are you using SQL for the dataset originally? Can you wrap that in a subquery and then perform you SQL operations on top of the sub query?