Hello, welcome back!
The Data Explorer plugin might be suitable for your use case.
You can use it as an API and create your query based on initial inputs.