[bug] These conversions are consistent, but not consistent in meaning ， from pg to mysql about sqlglot HOT 2 CLOSED

one:
select 1 from edw_dws.dws_loan_due_date_push_detail_v2 where confirm_date <= date(now() + '-21 days');

from sqlglot.

@Toms1999 I'm going to close these tickets as not planned.

Reviewing, reproducing and fixing issues is time-consuming and we're a small team, so we kindly ask that you put more effort into future reports. This means:

• Not ignoring the issue template in favor of making followup replies in the thread
• Clearly specifying what the input/output dialects are
• Explaining why the actual behavior is different from the expected, providing examples and documentation as needed
• Formatting the code appropriately so it's easy to parse
• Ideally, reducing the examples so that they're minimally reproducible, i.e. they don't contain irrelevant information

from sqlglot.