If the resulting data doesn't need formatting, try https://www.postman.com/ It's easy enough to write a few collections and train non-techies to use it.

If you are after richly formatted data then try Metabase https://www.metabase.com/