I understand that Wordpress allows you to create Custom Post Types with Custom Fields, but is it possible to create a custom Plug-In that creates and maintains its own Custom Post type (outside of Wordpress's Custom Posts)?
So for example, if you had a Wordpress site that had a the Custom Post Type "Event", along with Custom Fields like "Event Host", "Location", "Start Date", "End Date", "Entry Fee", etc.
The idea is that a custom Plug-In would allow finer control to view and sort selected records from the database. So for example, a user could ask to only see events by a certain Event Host, or that has an Entry Fee between certain thresholds.
Also, if the End Date had passed (i.e. the event had finished), then all search results would not display that Event any more.
I understand that most of this may be possible using Custom Post Types and Custom Fields using Wordpress, but I believe a lot of it is fiddly, limiting and slow. Being able to write the database schema and SQL statements would presumably give us a lot more power.
Does Wordpress allows such levels of customisation through plug-ins?