Ooops.. didn't notice the LIMIT # OFFSET # part. IMHO the idea sounds good and is definitely more readable.. and fair to both Mysql and postgresql loyalists ;). Postgres is backwards? Or did you mean you got the syntax backwards ? ;).
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных