We have a product in beta that (I think) does what you're looking for: the Query Library (https://docs.retool.com/docs/query-library). This lets you run queries, save them, and share them across your company. LMK if that's what you're looking for?
(In the future, we will be adding more permissions, etc. to it. We are actively developing this right now and would love to get some feedback from you on it if you'd be open to it? I will have our engineer email you!)