How can i have wordpress create "virtual" pages (or probably better suited: a different custom post type) taken from a DB Query?
The table in question could map out one resource (events in my case) per row. The entities are fed and managed by a legacy application and changes are made every now and then (too often to duplicate the data manually, they would be updated by a script).
I still want to be able to access each resource by a unique permalink and would like to be able to iterate over them (creating archive pages and so on).
I think pods try to achieve something like that with "Advanced Content Types" (http://pods.io/docs/learn/what-are-advanced-content-types/) but this seems to be an overhead.
One could also create just a single page with a given parameter (
events/show?slug=myevent1) but this is not SEO-friendly enough for my taste and throws away all the benefits the WP modeling gives us - with archives, metadata and stuff.
My question is not about the "techniques" like custom tables, SQL queries and stuff, rather how to model this behaviour exploiting all the WP stuff already there.