No support for the TABLESAMPLE clause (SQL 2003 / PostgreSQL)

[Tim Joseph Dumol]

There doesn't seem to be any built-in support for the TABLESAMPLE clause (searched docs and asked on SO [3]).

[1] https://www.postgresql.org/docs/9.5/static/sql-select.html [2] http://users.atw.hu/sqlnut/sqlnut2-chp-1-sect-2.html [3] https://stackoverflow.com/questions/37429476/how-to-tablesample-with-sqlalchemy

[Mike Bayer]

I'm assuming this is related to the PR just sent today at https://github.com/zzzeek/sqlalchemy/pull/277 (now in gerrit at https://gerrit.sqlalchemy.org/#/c/88/).

If not, it would be the most unbelievable coincidence.

[Tim Joseph Dumol]

Wow. That is pretty unbelievable. Gotta love time travelers.

EDIT: Then again, nevermind! It seems the guy who answered my SO question made that PR. That's awesome.

[Mike Bayer]

Add TABLESAMPLE clause support.

The TABLESAMPLE clause allows randomly selecting an approximate percentage of rows from a table. At least DB2, Microsoft SQL Server and recent Postgresql support this standard clause.

Fixes: #3718 Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277

→ <<cset 20f2f5b169d3>>