${if(edate=left(today(),7),

"select *

from xx

where 1=1

and date = '"+edate+"'",

"select *

from xx

where 1=1

and aaa

and date ='"+edate+"'"

)}

select * from XXX表

where 1=1

${if(edate="2023-11","and date='"+edate+"'","and aaa and date='"+edate+"'")}

select *

from xx

where 1=1

and date = '${edate}'

${if(edate='2023-11',"and aaa","")}

'2023-11'可以用一个参数代替，在参数里面做today公式变形

select *

from xx

where 1=1

and date = '${edate}' ${if(FORMAT(TODAY(),"yyyy-MM")=edate,""," and 1<>1")}

union all

select *

from xx

where 1=1

and aaa

and date ='${edate}' ${if(FORMAT(TODAY(),"yyyy-MM")=edate," and 1<>1","")}

${if(edate="2023-11","and 1=1","and 1=2")}