### Description

The date_xxx() arguments have been swapped to always have the field parameter last. This has been done to align with other implementations of similar functionality (which users would be accustomed to).
This issue is a reminder to remove this warning once any existing usages have been corrected.

Related: #98624, #99561.
x-pack/plugin/esql/src/test/java/org/elasticsearch/xpack/esql/analysis/AnalyzerTests.java
public void testChainedRenameReuse() {
        assertProjection("""
            from test
            | rename emp_no as r1, r1 as r2, r2 as r3, first_name as r1
            | keep r1, r3
            """, "r1", "r3");
    }
    public void testRenameBackAndForth() {
        assertProjection("""
            from test
            | rename emp_no as r1, r1 as emp_no
            | keep emp_no
            """, "emp_no");
    }
    public void testRenameReuseAlias() {
        assertProjection("""
            from test
            | rename emp_no as e, first_name as e
            """, "_meta_field", "e", "gender", "job", "job.raw", "languages", "last_name", "long_noidx", "salary");
    }
    public void testRenameUnsupportedField() {
        assertProjectionWithMapping("""
            from test
            | rename unsupported as u
            | keep int, u, float
            """, "mapping-multi-field-variation.json", "int", "u", "float");
    }
    public void testRenameUnsupportedFieldChained() {
        assertProjectionWithMapping("""
            from test