Tobias Brandt

TIL about **`NULL` aware comparisons in SQL** using ```sql IS [NOT] DISTINCT FROM ``` See Markus Winand's page: [NULL-Aware Comparison: is [not] distinct from](https://modern-sql.com/feature/is-distinct-from#:~:text=In%20SQL%20null%20is%20not,a%20particular%20value%20is%20null%20) This yields a better implementation for...

This page has an even better overview of [The Three-Valued Logic of SQL](https://modern-sql.com/concept/three-valued-logic). I haven't read all of it yet but one conclusion I came away with from that article...

> One thing that bothered me while reading this discussion was the handling of nulls in joins. > (It may be similar to the sort order problem that was found...

@max-sixty I concur your with your concern about the increase in cardinality with `from_csv`, `from_json`, `from_yaml`, ... . I'm also concerned about whether it won't potentially be confusing in databases...

`from_text` sounds good. --- RE: `from_file`, I agree that that's not needed now (or ever possibly). The DuckDB case works just fine with what we have at the moment because...

@vanillajonathan This has actually been implemented and the following works in the playground: ```elm from_text format:json '[{"a": 1 , "b":2}]' ``` I believe the following should work too but for...

Hey folks, I will be posting my PRQL syntax proposal soon. In the meantime, if you really want to go in-depth on Recursive CTEs, here's a link to an academic...

# Recursive CTEs for PRQL ## Recursive CTEs in SQL Thanks for the link to @frankmcsherry 's [blog post](https://github.com/frankmcsherry/blog/blob/master/posts/2022-12-25.md) @max-sixty. My mental model of Recursive CTEs much simpler and basically...

I read most of the [A Fix for the Fixation on Fixpoints](https://www.cidrdb.org/cidr2023/papers/p14-hirn.pdf) by [@Teggy](https://twitter.com/Teggy) and @kryonix last night and think that my Python description of how SQL Recursive CTE's work...

> As I see it, loop basically takes two values: initial function and iteration function. It's just that in your proposal, iteration function is expressed with a binding name and...