Grieve

Input SQL ```SQL SELECT COUNT(*) AS "count" FROM "tpch"."Orders" WHERE ("tpch"."Orders"."orderkey" IS NOT NULL) AND (("tpch"."Orders"."orderkey" ?) OR ("tpch"."Orders"."orderkey" IS NULL)) ``` Rewritten SQL ```SQL WITH "Orders" AS ( SELECT...

https://github.com/Canner/wren-engine/blob/88d527b241abdc5bd56e3bdf396c1d2b379d7aaf/wren-main/src/main/java/io/wren/main/wireprotocol/PostgresWireProtocol.java#L284-L286

We need to re-definiton the scope for the MDL. `WITH` is not in the MDL scope, so `getColumnType` will be failed in the `ExpressionTypeAnalyzer`. Like this case - TestAllRulesRewrite.testAccioNoRewrite("with normalCte...

When we analyze the prepare-statement for the function's return type, we don't have the parameter is what type when it is a `?` at the visitFunctionCall in the ExpressionTypeAnalyzer. https://github.com/Canner/accio/blob/e94fb56a61216295b57db776cafa6344b579d462/accio-tests/src/test/java/io/accio/testing/bigquery/TestFunctions.java#L109-L115

We missed the analysis of `having` at the visitQuerySpecification in the StatementAnalyzer. It should be like `analyzeWhere`. https://github.com/Canner/accio/blob/9dfc709d7d7bce8883947a035fc1badbfc9f85fe/accio-base/src/main/java/io/accio/base/sqlrewrite/analyzer/StatementAnalyzer.java#L312-L318

SQL parser parses the statement with the function `pg_relation_size` and will return the argument as `LongLiteral`. And the expression is transferred to BIGINT via `ExpressionTypeAnalyzer`. But we define the function...

BUG: DataFrame to JSON failed when it with UUID

2

### Pandas version checks - [X] I have checked that this issue has not already been reported. - [X] I have confirmed this bug exists on the [latest version](https://pandas.pydata.org/docs/whatsnew/index.html) of...

fix(uri-parsing): handle password with bracket in connection url

1

## Description of changes If the password is with a bracket in the connection url, `urllib.parse.urlparse(url)` will raise the error `ValueError: Invalid IPv6 URL` in `backends.connect()`. But if the caller...

### What happened? The document website has a description of the MSSQL that could use a connection URL to connect. https://ibis-project.org/backends/mssql#ibis.connect-url-format But actually backends.mssql inherits `NoUrl` and does not implement...

## TL;DR DuckDB could not connect to DuckDB's download extensions web. ## Description The error message ``` java.util.concurrent.CompletionException: java.lang.RuntimeException: java.sql.SQLException: java.sql.SQLException: Extension Autoloading Error: An error occurred while trying to...