From 86c29b46f4c7494401cc2ee272d0dec2b8256eff Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 13:14:27 +0200 Subject: Adding upstream version 23.13.7. Signed-off-by: Daniel Baumann --- docs/sqlglot.html | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'docs/sqlglot.html') diff --git a/docs/sqlglot.html b/docs/sqlglot.html index 2442e43..ce92b08 100644 --- a/docs/sqlglot.html +++ b/docs/sqlglot.html @@ -361,7 +361,7 @@

Unsupported Errors

-

It may not be possible to translate some queries between certain dialects. For these cases, SQLGlot may emit a warning and proceeds to do a best-effort translation by default. Transpilation is difficult and not all permutations are supported. If transpilation does not work, it may not be implemented yet. Well documented / tested PRs / issues are appreciated. Some transpilation cases that require db schemas are made possible through the optimizer but are not included in base transpilation:

+

It may not be possible to translate some queries between certain dialects. For these cases, SQLGlot may emit a warning and will proceed to do a best-effort translation by default:

import sqlglot
@@ -386,6 +386,10 @@
 
sqlglot.errors.UnsupportedError: APPROX_COUNT_DISTINCT does not support accuracy
 

 
+
There are queries that require additional information to be accurately transpiled, such as the schemas of the tables referenced in them. This is because certain transformations are type-sensitive, meaning that type inference is needed in order to understand their semantics. Even though the qualify and annotate_types optimizer rules can help with this, they are not used by default because they add significant overhead and complexity.

+
+
Transpilation is generally a hard problem, so SQLGlot employs an "incremental" approach to solving it. This means that there may be dialect pairs that currently lack support for some inputs, but this is expected to improve over time. We highly appreciate well-documented and tested issues or PRs, so feel free to reach out if you need guidance!

+
 
Build and Modify SQL

 
 
SQLGlot supports incrementally building SQL expressions:

-- 
cgit v1.2.3