(2012-01-19 09:40)xbmcg Wrote: The issue ist not just about the database drivers, but also about the SQL dialect, MSSQL Queries have a slightly different syntax / functions for string manipulations, concatenations, table joins, triggers, stored procedures, parameter handling etc. If you have to support both, you have to re-write all queries to this target, or buld neutral wrapper that creates the right output for the different targets.
Yes, however, if you was using stored procedures in the first place rather then directly querying the tables, you would be calling GetVideoLibrary() rather then SELECT * FROM [MyVideos]
This would be theoretically possible in both MySQL and MSSQL, and while would require a single time change in queries, would expand for DB options everywhere, if you was to interface it, and have the implementation as a plugin, that would potentially remove all problems and put the ball back into someone else's court (aka. any plugin developer that wants to spend time on it)
EDIT: If someone (a dev probably) with a little more experience in XBMC would be so kind as to chime in I would much appreciate knowing if it would be technically possible rather then theoretically