Support for creating queries via initialized JpqlDsl object.

[shouwn]

Backgrounds

• Queries are created by JpqlDsl.
• But the only way to use JpqlDsl object is to implement the JpqlDsl.Constructor interface.
• This makes it impossible to inject dependencies to JpqlDsl.

Objects

• Create a new entry point to use the JpqlDsl created and managed by the user.

Benefits

• Avoid creating redundant JpqlDsl objects every time.
• Allowing JpqlDsl to reference other objects offers more extension points for users to customize at little cost without implementing JpqlSerializer.
  • Automatically encrypting or hashing strings reduces redundant code without static.

Requirements

• Makes it possible for jpql functions to accept JpqlDsl object as a parameter.
• Makes it possible for functions provided by support to accept JpqlDsl object as a parameter.

Contribution

• Please check if there is an assignee in this issue. And if it don't have an assignee, please leave comment to assign.
• Please check the commit convention through the commitlint.config.js file. The commit convention also described in the PR template.
• When you use intellij, please set the code style through the .editorconfig file.
• Please create the PR for develop as the base branch.
• If you have any questions, please leave comment in Kotlin-JDSL Discord Channel in LINE Open Source

[jbl428]

I have some question before working on this issue. I would like to confirm if I understood the issue correctly.

The following changes are needed.

• Jpql.kt

  inline fun <DSL : JpqlDsl, Q : JpqlQuery<Q>> jpql(jpql: DSL, init: DSL.() -> JpqlQueryable<Q>): Q {
  return jpql.init().toQuery()
  }

• KotlinJdslJpqlExecutor.kt (one of support modules)

fun <T : Any, DSL : JpqlDsl> findAll(
    dsl: DSL,
    init: DSL.() -> JpqlQueryable<SelectQuery<T>>,
): List<T?>

// and other methods and modules

After, the user can register custom beans in Spring as follows:

@Component
class MyJpql(
    private val encryptor: Encryptor,
) : Jpql() {

    fun myFunction(value: String): Expression<String> {
        val encrypted = encryptor.encrypt(value)
        return function(String::class, "myFunction", listOf(value(encrypted)))
    }
}

If this is right, I would like to take this issue.

[shouwn]

@jbl428 Oh, I'm so sorry.... I wasn't notified of this issue and didn't realize you had commented.

You're right. If you're still interested in working on this, please comment again.

I'm really sorry for this late response... 😢

[jbl428]

@shouwn It's okay. I'm glad that I understood correctly. 😄 I want to take on this task.

[shouwn]

I appreciate your thoughtfulness. I have changed the assignee to you.