There's an open source project which is a syslog daemon that stores logs in DuckDB. You can configure journald to forward logs to it.

https://github.com/phare/sloggo