We store our logs in PostgreSQL and use Metabase for visualisations & analysis: https://metabase.com/

It's still focused on SQL but the "Question" flow is quite simple, and doesn't require you to write SQL. You can, of course, write raw SQL if you want to and have those results still visualised.