Add locking clause syntax to dialect

This patch was authored and released by @gwynne.

Leverages the new functionality in vapor/sql-kit#154 to provide the correct syntax for both shared and exclusive locking clauses in PostgreSQL.