fixes #2252

fixes #1339
closes #921

Use shorter table names - Oracle allows max 30 characters - http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm#sthref723

Features and changes:
* jsonb can be used with: options={"jsonb"=true}
* OVER is no longer reserved
* LATERAL is now reserved

Can't use short array in php < 5.4

Because PostgreSQL will return the expression with a lot of
parentheses we cannot TRIM() them easily. It is easier and more
correct to adapt to what PostgreSQL returns. That means the declaration
of partial indexes must be updated as follow:

Before:
``options={"where": "other_id IS NULL"}``

After:
``options={"where": "(other_id IS NULL)"}``

And fore more complex conditions, that would be:
``options={"where": "(((id IS NOT NULL) AND (other_id IS NULL)) AND (name IS NULL))"}``