Lower function missing

[mibes404]

Description

The lower function was added to sea-query "0.24.0", but sea-orm 0.7.1 depends on sea-query "0.23.0".

Background

We're migrating a project from Diesel to sea-orm, and need the lower function to perform a case-insensitive compare.
Updating the dependency will allow us to write something like:

let like = format!("%{}%", default.to_lowercase());
Expr::expr(Func::lower(Expr::col(column))).like(&like)

which can be used to produce something like:

SELECT LOWER("first_name") LIKE '%bob%' FROM "character"

Versions

sea-orm v0.7.1

Additional Information

I'll submit a pull request to update the dependency and link it with this issue.

[ikrivosheev]

@mibes404 can we close issue?

[mibes404]

Thanks!