psql – Best client to give READ access

Some of the people I work with want access to the database (PSQL), to be able to search and export a CSV format of their results.

My idea was to create a View, and have a “read-only user” so they could connect to Adminer and do their search without having to write sql.

I wonder if this is the right way to go ?
What should I keep in mind?
Is there a better tool than Adminer for that purpose?

My stack runs in docker, though I don’t think that’s relevant.

Thanks