Simple SQL statement generation with Repository object

[lizhihui888]

Feature Description

I want to generation query conditions SQL with Repository object like this:

where type = 1 and ( name = 'keyword' or code = 'keyword')

The code example is as follows:

this._repository.findOneBy({
    type:1,
    // name:'keyword' || code:'keyword' // how ?
 })

Do not use the Query Builder , only use Repository , what should I do ? thanks

The Solution

I want to generation query conditions SQL with Repository object like this:

where type = 1 and ( name = 'keyword' or code = 'keyword')

The code example is as follows:

this._repository.findOneBy({
    type:1,
    // name:'keyword' || code:'keyword' // how ?
 })

Do not use the Query Builder , only use Repository , what should I do ? thanks

Considered Alternatives

I want to generation query conditions SQL with Repository object like this:

where type = 1 and ( name = 'keyword' or code = 'keyword')

The code example is as follows:

this._repository.findOneBy({
    type:1,
    // name:'keyword' || code:'keyword' // how ?
 })

Do not use the Query Builder , only use Repository , what should I do ? thanks

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, and I know how to start.