(this could have went in a comment, but I do not have enough reputation for posting one)

Odd, the provided query does work for me out of the box. Do you happen to have QUOTED_IDENTIFIERS_IGNORE_CASE set to TRUE (try SHOW PARAMETERS LIKE 'QUOTED_IDENTIFIERS_IGNORE_CASE')? Either way, qualifying the table name does allow me to retrieve the value in the column regardless of that:

select * from TEST t where t."current_date" ='2027-10-01' limit 10;