Hi Michael,
Everything you mention above is easily achievable with Wappler after a little bit of learning the basics of relational databases. Essentially it is very simple after you have a grasp on the way things operate. Wappler makes it easy to build this type of application.
Documentation is here:
Inserting records:
https://docs.wappler.io/t/insert-database-record/2863
Creating queries:
https://docs.wappler.io/t/creating-database-queries/2872
Filtering:
https://docs.wappler.io/t/filtering-database-query-with-a-text-input/2869
https://docs.wappler.io/t/filtering-database-query-with-an-url-parameter/2868
Along with the Wappler documentation there is also a fine selection of videos available over on the DMXzone official website (featuring the App Connect and Server Connect frameworks):
And for some great guidance on MySQL and RDB's in general check out: