> I'm currently looking for a solution to provide (non-technical) team members with a way to interact with a SQL database ... While I'm generally willing to pay, I'd really prefer an open and self-hosted solution.
You should definitively check Metabase [0] then: it's open source, very easy to self-host, and democratize data access inside your team. We started using it for the same reason 3 years ago, I cannot recommend it more.