I'm switching to PostgreSQL... but there I'm hitting another issue where I issue "ORDER BY" (with server-side pagination), yet the results are always ordered by primary key... I found a thread similar to my problem Sort columns when server side pagination is enabled
Turning off prepared queries helps... but it's dangerous...