hlcianfagna

I see your point, and I agree it is not a priority, but it is something that came directly from an actual customer. I think it is something that becomes...

FWIW - I did a test against a real PostgreSQL instance collecting logs with `log_statement=ALL` and `log_min_duration_statement=0` to see if there would have been any other blockers for Qlik Cloud...

Please see example below of how with the current implementation subqueries can be faster than JOINs in scenarios where a `LEFT JOIN` is required as there may not be matching...

Just a quick note to mention that the `vector_distance` and `n_dimensional_distance` functions from https://community.crate.io/t/a-collection-of-useful-user-defined-functions-udfs/773 can be used as a workaround.

All required for basic usage, except `AlterTableRename`, `pg_terminate_backend`, and `TRUNCATE`

Sure, so this is about migrating stored-procedures logic to CrateDB. Imagine a batch of statements in a .sql file that we pipe to `crash`. (of course the original code being...

This would be a great optimization. Please note that even if the fields on both sides would allow nulls the join would not happen anyway because `NULL` does not equal...

> @hlcianfagna could you elaborate a bit more on the problem? "Could add it for improved compatibility" applies for all features of the SQL Standard which we're still missing. Hi,...

Hi, UDFs are a particular case when it comes to terminating queries I think, but you can simply run a large `INSERT INTO` like: ```sql CREATE TABLE tbl1 (a text);...

> I'm missing the ability to define my own aggregation functions. Hi, it is a workaround, but you may want to take a look at how this is achieved with...