<p dir="auto"><strong>Migrated issue, originally created by paj (<a href="https://github.com/paj">@paj</a>)</strong></p>
<p dir="auto">MSSQL does not natively support LIMIT with an OFFSET, but it may be possible to emulate the behavior. One option is to use MSSQL 2005's ROW_NUMBER() function; another is just to seek the cursor by the offset.</p>
<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">It could be very useful (at least for me) if SQLAlchemy can support manually add Oracle hints (<a href="http://www.adp-gmbh.ch/ora/sql/hints/index.html" rel="nofollow">http://www.adp-gmbh.ch/ora/sql/hints/index.html</a>).</p>
<p dir="auto">This can be useful because sometimes Oracle (in version 10, the 11 should be better), isn't able to optimize the request the right way, and a little hint like /<em>+ INDEX(TABLE)</em>/ manually added can drastically improve the performance.</p>
<p dir="auto">I tried to add this feature in SQLAlchemy 0.5.3, but the architecture is a bit complicated for me to understand.</p>
<p dir="auto">I can try again to modify the source code and propose a patch, but I need a little help on how to "cleanly" integrate this functionnality into SQLAlchemy.</p>
<p dir="auto">You can contact me at canarix (at) gmail</p>
<p dir="auto">Thanks in advance,</p>
<p dir="auto">CanariX</p>