Creating custom query page from input

I would like to have pages generated without actually creating static pages as the number of pages I’d need would be about 10,000 – possibly more. i have a website that accesses a database for results that is dynamic. Event tickets. Right now the results pages are static – ie NFL, NBA and MLB teams. An example is https://www.eztickets4.me/ – https://www.eztickets4.me/#mlb and https://www.eztickets4.me/sports/baltimore-orioles-tickets
What I’d like to do is to generate that last page without actually making it a static page. Is this possible with WP or do I need to look for some other platform?