What you wrote about search looks exactly like common SQL queries in relational database, also you mentioned that you are not alone working with this data so you’ll need to provide an access to that data to control who can do what.
If you have any even completely inexperienced or aspiring developer inside your team they would be able to do something just fine, not fast though.
I’m not sure how do you intend to use it precisely but you can also just create database and learn basics of SQL and I mean really basic stuff to just be able to join few tables.
And then it’s not clear where you current data is persisted.
For more complex scenarios you’ll probably need actual development.
And one more thing, there is this thingy called excel. It can connect to datasources such as postgres, with a bit of tweaking and vlookup you can create really complex and detailed spreadsheets
What you wrote about search looks exactly like common SQL queries in relational database, also you mentioned that you are not alone working with this data so you’ll need to provide an access to that data to control who can do what.
If you have any even completely inexperienced or aspiring developer inside your team they would be able to do something just fine, not fast though.
I’m not sure how do you intend to use it precisely but you can also just create database and learn basics of SQL and I mean really basic stuff to just be able to join few tables.
And then it’s not clear where you current data is persisted.
For more complex scenarios you’ll probably need actual development.
And one more thing, there is this thingy called excel. It can connect to datasources such as postgres, with a bit of tweaking and vlookup you can create really complex and detailed spreadsheets