peasee opened a new issue, #12160: URL: https://github.com/apache/datafusion/issues/12160
### Describe the bug Using an SQLite connection with `SqliteDialect`, and run a query that uses a date extraction function like `extract(year from date_column)`. The unparser rewrites this to `date_part`, but SQLite only supports [`strftime`](https://www.sqlite.org/lang_datefunc.html#strftm) so the query fails. ### To Reproduce _No response_ ### Expected behavior The unparser should re-write the query to `strftime` to correctly extract the desired date information. ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
