Can someone recommend whats the best way to connect to a memory DuckDB instance from php(php_fpm) and get return in usable format?

E.g. would be used for offline statistical analysis

Alterntively, any way to export cli sql results as csv?