Support escaping variable names

[augustobmoura]

Steps to Reproduce

1. Configure a project with micronaut and micronaut data
2. Create a Postgres database
   3 Try to use a native query with cast using double colon:

@Repository
interface FooRepository {
  @Query(value "SELECT '1'::INTEGER", nativeQuery = true)
  Integer findConstant();
}

Shoul throw a error because INTEGER is not a declared parameter (all fine until here)
4. Try to escape the colons to force them to not be understood as a parameter

@Repository
interface FooRepository {
  @Query(value "SELECT '1'\\:\\:INTEGER", nativeQuery = true)
  Integer findConstant();
}

Expected Behaviour

To be possible to escape colons in native queries

Actual Behaviour

It still throws a error at compile time telling that INTEGER is not a declared parameter

Environment Information

• Operating System: Ubuntu 18.04
• Micronaut Version: 1.3.0/ Data: 1.0.0
• JDK Version: Adopt11+OpenJ9

Edit:
I'm solving this problem at the moment by using the other syntax for casting in postgres https://www.postgresql.org/docs/current/typeconv-func.html

[augustobmoura]

I tracked the bug to lines:

micronaut-data/data-model/src/main/java/io/micronaut/data/model/query/builder/QueryBuilder.java

Line 49 in 69c7df0

Pattern VARIABLE_PATTERN = Pattern.compile("(:([a-zA-Z0-9]+))");

and:

micronaut-data/data-processor/src/main/java/io/micronaut/data/processor/visitors/finders/AbstractPatternBasedMethod.java

Line 482 in 80a7008

Matcher matcher = QueryBuilder.VARIABLE_PATTERN.matcher(queryString);

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.