Fully reproducible code snippet
The following SQL query using PostgreSQL-style typecast is legal in Postgres and Redshift
select col is not null::boolean from table
Sqlglot error:
>>> parse_one("select col is not null::bool from table", read="postgres")
sqlglot.errors.ParseError: Invalid expression / Unexpected token. Line 1, Col: 24.
select col is not null::bool from table