We don't believe AGPL should prevent you from self-hosting for your own internal usage. We see ourselves as becoming a Postgres-based Elasticsearch alternative, primarily used internally for observability, etc.
If you are interested in using ParadeDB to power your own product, or would prefer a different license, we'd love to hear from you. You can reach me directly at phil@paradedb.com.
We spent a lot of time evaluating which license to use, and decided to follow the footsteps of Citus Data and go with a standard OSS license while ensuring that we can't be hosted on public clouds without a partnership. Hope this helps!