The main use case is benchmarking simple CPU-bound query variants against each other during local development. Only PostgreSQL is supported at this point, but pull requests for MySQL or other ...
Succinctly, we "pivot" Xarray Datasets (with consistent dimensions) to treat them like tables so we can run SQL queries against them. This is a light-weight way to prove the value of the interface.