I don't know how (and if) it's possible, but it would be interesting to have a kind of wait mode. My use case is use duckdb with gcp cloud run, a serverless docker service. I imagine something like
duckdb :memory: "LOAD httpserver; SELECT httpserve_start('0.0.0.0', 9999, wait=true); And duckdb wait until a signal kill the process.