`join` inside a `group` clause causes panic

[albx79]

What happened?

I wrote a query that should select all companies with more than one addreses, and list all addresses except the most recent one.

However, I get a compiler panic on the playground.

PRQL input

from c = companies
join ca = companies_addresses(c.tax_code == ca.company)
group c.tax_code (
  join a = addresses(a.id == ca.address)
  sort {-ca.created_at}
  take 2..
)
sort tax_code

SQL output

A compiler bug was encountered. Please copy/paste the PRQL query into a new report at:
   https://github.com/PRQL/prql/issues/new?template=bug_report.yaml

Expected SQL output

(I have no idea how to write this query in SQL)

MVCE confirmation

• Minimal example
• New issue

Anything else?

It may be related to #3870

[vanillajonathan]

The application panicked (crashed).
Message: called Option::unwrap() on a None value
Location: prqlc/prqlc/src/semantic/module.rs:258

prql/prqlc/prqlc/src/semantic/module.rs

Lines 256 to 258 in be0f2da

	match column {
	LineageColumn::All { input_id, .. } => {
	let input = lineage.find_input(*input_id).unwrap();