support for ASOF joins

[era127]

What's up?

I am starting to look at PRQL and I was wondering if there is the possibility to support ASOF joins such as in duckdb I understand this type of support is not in standard sql but It would help to have it translated.

[max-sixty]

Yes I think this makes sense, and would be quite easy — maybe as easy as adding it to

prql/crates/prql-compiler/src/ir/pl/extra/expr.rs

Lines 112 to 118 in 04b5174

	#[derive(Debug, PartialEq, Eq, Clone, Serialize, Deserialize)]
	pub enum JoinSide {
	Inner,
	Left,
	Right,
	Full,
	}

and catching any places where that's matched against...

[xueyumusic]

It looks depending on sqlparser crate here. So does it mean need to add support in sqlparser crate first?

[max-sixty]

It looks depending on sqlparser crate here. So does it mean need to add support in sqlparser crate first?

Coming back to this issue — this is correct... I think that would likely be a welcome contribution for them, and not that much code...

[max-sixty]

FYI this is now released upstream! So could be a reasonable contribution to PRQL

apache/datafusion-sqlparser-rs#1288