But, beam-sqlite backend doesn't seem to implement full join and is not distinct from and FILTER (WHERE ...) and common table expressions.
It's painful to read CASE .. WHEN .. instead of is not distinct from in generated SQL queries.
Implementing those will speed up sqlite queries.