Zend Framework 2, PDO dblib driver, how to change SQL Platform Decorator

Zend Framework 2, PDO dblib driver, how to change SQL Platform Decorator

It seems that ZF2 with the PDO:dblib driver defaults to using the SQL92
SQL decorator. How do I use the DI system to tell it to use the SqlServer
decorator instead? Just can't get my head around it.
The issue is that the paginator attempts to use LIMIT/OFFSET syntax which
doesn't work in SQL Server.
Chris