RY "LIKE" conditions do not work with MS SQL Server

Description

Under Microsoft SQL Server,

We can type: key ~ 'REQ%'
But we can't type: key ~ 'REQ_FN_%'

Because _ is a wildcard that we intend to disable for user-facing interactions, so we escape it, but MS SQL requires the ESCAPE clause. Example :

We must include the ESCAPE part in MS SQL.

Environment

None

Observations

None
Resolved

Assignee

Unassigned

Reporter

Adrien Ragot (Play SQL / Requirement Yogi)

Labels

None

Participants

None

Components

Sprint

Fix versions

Priority

Matter of days