Filter by the concatenation of two columns

Suggestion

It would be nice to be able to filter a Model by the concatenation of two columns.
I mean, to be able to replicate this type of SQL query:

SELECT * FROM User WHERE CONCAT(name, ' ', lastName) LIKE '%PARTIAL FULLNAME%'

Use Cases

The most common example is filtering a User model by its full name when it's stored in two columns (name, lastName).
Currently, the only way this is possible (AFAIK) is by sending the RAW query, which makes it almost incompatible with adding more filters.

Examples

Table example:

Example of one (possible) implementation of filter object:

{
  "limit": 10,
  "offset": 0,
  "where": {
    "leavingDate": null,
    "concat": {
      "eq": "%on B%",
      "separator": " ",
      "columns": [
        "name",
        "lastName"
      ]
    }
  }
}

Should return:

Acceptance criteria

TBD - will be filled by the team.

まず、提案されている where.concat フィルターオブジェクトと、リポジトリのフィルターが現在 raw query をどのように扱っているかを確認します。サポートするカラム、区切り文字、比較演算子、データベースの動作を含む受け入れ条件をチームと明確にします。他のフィルターと併用して連結によるフィルタリングが機能し、検証結果が文書化されていれば完了です。