Unknown table 'pb_bi_date_type' in where clause

Hi @wzc
Please read this article: https://www.metabase.com/learn/sql-questions/field-filters
When using Field Filters, you need to reference the table without alias and not include column or operator.