How to run optimize an expression?

[evyasonov]

I want to optimize dt BETWEE date '2023-04-08' - interval '7' day AND date '2023-04-08' into dt BETWEE date '2023-04-01' AND date '2023-04-08'. Other words I want to collapse interval. It's not a select, it's a logical expression. How can I do it? I tried sqlglot.optimizer.optimize, but it throws OptimizeError: Unexpected expression type: <class 'sqlglot.expressions.Between'>

Can you help please

[evyasonov]

Seems that sqlglot.optimizer.simplify.simplify(expression).sql() works