Added support of optional `dialect` parameter

[ovcharenko]

The current implementation hard-codes postgres as the only supported SQL dialect, making it impossible to extend. This PR solves the problem.