I created a Question based on native query that uses also a field filter . The native query uses a join between two tables - the query works before adding the field filter. When adding the field filter and entering value the preview query includes:
where CAST("public"."table_name"."created_at" AS date) = date '2023-10-19'
this table i gave the alias l in the join - but getting this error:
invalid reference to FROM-clause entry for table "table_name" Hint: Perhaps you meant to reference the table alias "l"
Is this a known issue ? is there a workaround for it ?