Set temporary cache locations of dependencies from one location

At the moment, temporary cache locations may be specified for `cloudpathlib` use in CytoTable by using the `cytotable.convert(..., local_cache_dir='',...)` `local_cache_dir` parameter (via `**kwargs`). `sqlite3` includes an additional cache layer which is sometimes used for mixed data type column translation which is specified through environment variables ([see here](https://www.sqlite.org/tempfiles.html)) or a PRAGMA command ([see here](https://www.sqlite.org/pragma.html#pragma_temp_store_directory)). It might be possible to explicitly set these to the same location for simplicity, or to set them from the individual queries for SQLite somehow.

Start by reading the `cytotable.convert(..., local_cache_dir='',...)` path described in the issue, then review SQLite's temp-file and `temp_store_directory` documentation. Determine whether both cache locations can safely share one setting or be set per query; done means the intended configuration and its limits are clearly defined.

Written by the indexing model from the issue text.