[Bug]: filter endsWith: "_" is incorrectly resolved

[martinb-mpreis]

What happened?

I created a query like

query Customers{
    customer(
        filter: { id: {endsWith: "_CON" } }
    ) {
        endCursor
        hasNextPage
        items {
            id
        }
    }
}

I received an empty json response, although the database contains customers with ids ending like "_CON".

I investigated the SQL queries the database receives and found this.

WHERE Id LIKE '%\_CON'

Version

1.2.11+c7ca8db8558a63919c530e454c8f18b45d5b931c

What database are you using?

Azure SQL

What hosting model are you using?

Container Apps, Local (including CLI)

Which API approach are you accessing DAB through?

GraphQL

Relevant log output

No response

Code of Conduct

• I agree to follow this project's Code of Conduct