In current implementation of ProviderSqlSource, it does not allow replacing configuration properties using placeholder(${...}). I want to allow replacing it using placeholder as follow:
<properties>
<property name="Constants.LOGICAL_DELETE_OFF" value="false"/>
</properties>
public String buildSql(@Param("name") final String name) {
return new SQL(){{
SELECT("*");
FROM("test");
if (name != null) {
WHERE("name like #{name} || '%'");
}
WHERE("logical_delete = ${Constants.LOGICAL_DELETE_OFF}");
}}.toString();
}