Jo

Similar to https://github.com/tobymao/sqlglot/pull/3357 - Postgres doesn't support `COMMENT` post-schema properties. Reference: https://www.postgresql.org/docs/current/sql-createtable.html

Various unit test improvements

2

- [x] Add option for allowing empty / unspecified columns in unit tests (related Slack thread [here](https://tobiko-data.slack.com/archives/C044BRE5W4S/p1698620706683929)) The use-case for this is that one can have wide tables but they...

Don't create temp tables at plan time unless they're actually needed

1

We currently create temporary tables at plan time preemptively, even though they may not necessarily be needed. This behavior was introduced before we started to create tables on demand (i.e.,...

Fixes #3537

Context around `exp.AlterTable -> exp.Alter`: https://github.com/tobymao/sqlglot/commit/0428c37e11f42be8eba352e69c1d2e7425824d38

This PR makes the `columns_to_types` method more lenient by leveraging any existing snapshots in the evaluator's context as a fallback to fetch the target model's schema. The motivation can be...

To reproduce the bug: 1. Create new SQLMesh project using `sqlmesh init postgres --template empty` - Postgres is the default dialect because its normalization strategy is `LOWERCASE`, i.e. it treats...

Previously, the `Cursor.fetch_dataframe` method lowercased column names preemptively, thus not respecting the [case-sensitivity configuration value](https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_identifier.html). This could lead to issues, when e.g. two different columns resolved to the same name...

## Driver version 2.1.3 ## Redshift version PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.76169 ## Client Operating System macos ## Python...