CDBICompat is good enough that many CDBI plugins will work with CDBICompat, but many of the plugin features are better done with DBIx::Class methods.
search_where() is fully emulated using DBICs search. Aside from emulation theres no reason to use search_where().
nocache is fully emulated.
The features of CDBI::Sweet are better done using DBIC methods which are almost exactly the same. It even uses Data::Page.
This plugin will work, but it is more efficiently done using DBICs native search facilities. The major difference is that DBIC will not infer the join for you, you have to tell it the join tables.
In fact, this class is just a recipe containing all the features emulated.
If you like, you can choose which features to emulate by building your
own class and loading it like this:
this will automatically load the features included in My::DB::CDBICompat,
provided it looks something like this: