1. A computer implemented method for run-time SQL language translation, the method comprising: receiving, from an application, a query for execution, the query comprising dynamically generated SQL, the query being constructed in a foreign SQL dialect that is incompatible with a native SQL dialect of a native database system, wherein the dynamically generated SQL is constructed at run-time by the application; and performing real-time translation of the query from the foreign SQL dialect into the native SQL dialect, in which the query is intercepted to perform the real-time translation and the query is translated prior to returning results of the query to the application, wherein performing real-time translation of the dynamically generated SQL comprises: excluding literal values from the dynamically generated SQL; performing pattern matching on portions of the dynamically generated SQL excluding the literal values; identifying one or more canonical templates corresponding to the portions of the dynamically generated SQL excluding the literal values; translating the dynamically generated SQL excluding the literal values from the foreign SQL dialect into the native SQL dialect using the one or more canonical templates to generate a translated SQL; and inserting the literal values that were excluded from the dynamically generated SQL into the translated SQL.