django-snowflake
django-snowflake copied to clipboard
Snowflake-Labs
I see in the README under known issues: "Snowflake doesn’t support last_insert_id to retrieve the ID of a newly created object. Instead, this backend issues the query SELECT MAX(pk_name) FROM...
(This PR is left open to check these tests from time to time. We don't need to run them for every change.)
Hi, Due to legacy reasons, I need to deal with Snowflake tables having a name containing the schema in the format `DBO.TABLENAME`. However, I am unable to perform the inspectdb...
Due to snowflake-connector-python's [lack of VARIANT support](https://github.com/snowflakedb/snowflake-connector-python/issues/244) (I think it's difficult if not impossible to fix this otherwise), some `JSONField` queries with complex JSON parameters don't work. For example, if...
`DatabaseIntrospection.identifier_converter()` doesn't handle lower case or mixed case identifiers properly.
When loading fixtures that have primary key values of autoincrement columns specified, Snowflake doesn't automatically update the sequence to the next available value. For example, after loading fixtures with pk=1...
Django's database cache backend doesn't work with Snowflake because it [includes SQL queries that don't quote all of the fields](https://code.djangoproject.com/ticket/33340) as Snowflake requires (e.g. [expires](https://github.com/django/django/blob/main/django/core/cache/backends/db.py#L231)). Also, the `createcachetable` management command...
A queryset like: ```python Experiment.objects.filter(start=F('start') + F('estimated_time') ``` where `estimated_time` is a `DurationField`, generates SQL: ```sql WHERE "experiment"."start" = ("experiment"."start" + INTERVAL '"expressions_ExPeRiMeNt"."estimated_time" MICROSECONDS') ``` but `INTERVAL` doesn't support column...
A queryset like: ```python Experiment.objects.annotate(shifted=ExpressionWrapper( F('completed') - Value(None, output_field=DurationField()), output_field=DateField(), )) ``` generates ``` SELECT ("experiment"."completed" - INTERVAL 'NULL MICROSECONDS') AS "shifted" FROM "experiment" ``` which fails with `syntax error...