How to use

Template

in

org.hibernate.sql

  final String field = extractUntil( tokens, "from" );
  final String source = renderWhereStringTemplate(
      extractUntil( tokens, ")" ),
      placeholder,
      dialect,
          renderWhereStringTemplate( trimOperands.trimSpec, placeholder, dialect, functionRegistry )
      );
  result.append( renderWhereStringTemplate( trimOperands.trimSource, placeholder, dialect, functionRegistry ) )
      .append( ')' );
else if ( isNamedParameter(token) ) {
  result.append(token);
else if ( isIdentifier(token)
    && !isFunctionOrKeyword(lcToken, nextToken, dialect , functionRegistry) ) {
  result.append(placeholder)
      .append('.')
    beforeTable = true;
  if ( isBoolean( token ) ) {
    token = dialect.toBooleanValueString( Boolean.parseBoolean( token ) );

/**
 * Performs order-by template rendering without {@link ColumnMapper column mapping}.  An <tt>ORDER BY</tt> template
 * has all column references "qualified" with a placeholder identified by {@link Template#TEMPLATE}
 *
 * @param orderByFragment The order-by fragment to render.
 * @param dialect The SQL dialect being used.
 * @param functionRegistry The SQL function registry
 *
 * @return The rendered <tt>ORDER BY</tt> template.
 *
 * @deprecated Use {@link #translateOrderBy} instead
 */
@Deprecated
public static String renderOrderByStringTemplate(
    String orderByFragment,
    Dialect dialect,
    SQLFunctionRegistry functionRegistry) {
  return renderOrderByStringTemplate(
      orderByFragment,
      NoOpColumnMapper.INSTANCE,
      null,
      dialect,
      functionRegistry
  );
}

private static boolean isFunctionOrKeyword(
    String lcToken,
    String nextToken,
    Dialect dialect,
    SQLFunctionRegistry functionRegistry) {
  return "(".equals( nextToken ) ||
      KEYWORDS.contains( lcToken ) ||
      isType( lcToken, dialect ) ||
      isFunction( lcToken, nextToken, functionRegistry ) ||
      dialect.getKeywords().contains( lcToken ) ||
      FUNCTION_KEYWORDS.contains( lcToken );
}

public static String renderWhereStringTemplate(String sqlWhereString, Dialect dialect, SQLFunctionRegistry functionRegistry) {
  return renderWhereStringTemplate(sqlWhereString, TEMPLATE, dialect, functionRegistry);
}

hasOrder = sqlOrderByString != null;
sqlOrderByStringTemplate = hasOrder ?
    Template.renderOrderByStringTemplate(sqlOrderByString, dialect) :
    null;
sqlWhereString = collection.getWhere();
hasWhere = sqlWhereString != null;
sqlWhereStringTemplate = hasWhere ?
    Template.renderWhereStringTemplate(sqlWhereString, dialect) :
    null;
manyToManyWhereTemplate = manyToManyWhereString == null ?
    null :
    Template.renderWhereStringTemplate( manyToManyWhereString, factory.getDialect() );

  result.append(token);
else if ( isNamedParameter(token) ) {
  result.append(token);
  isIdentifier(token, dialect) &&
  !isFunction(lcToken, nextToken, dialect)
) {
  result.append(placeholder)

hasWhere = sqlWhereString != null;
sqlWhereStringTemplate = hasWhere ?
    Template.renderWhereStringTemplate( sqlWhereString, dialect, factory.getSqlFunctionRegistry() ) :
    null;
if ( hasOrder ) {
  LOG.debugf( "Translating order-by fragment [%s] for collection role : %s",  collectionBinding.getOrderBy(), getRole() );
  orderByTranslation = Template.translateOrderBy(
      collectionBinding.getOrderBy(),
      new ColumnMapperImpl(),
manyToManyWhereTemplate = manyToManyWhereString == null ?
    null :
    Template.renderWhereStringTemplate( manyToManyWhereString, factory.getDialect(), factory.getSqlFunctionRegistry() );
  manyToManyOrderByTranslation = Template.translateOrderBy(
      collectionBinding.getManyToManyOrdering(),
      new ColumnMapperImpl(),

private static boolean isFunctionOrKeyword(String lcToken, String nextToken, Dialect dialect, SQLFunctionRegistry functionRegistry) {
  return "(".equals(nextToken) ||
    KEYWORDS.contains(lcToken) ||
    isFunction(lcToken, nextToken, functionRegistry ) ||
    dialect.getKeywords().contains(lcToken) ||
    FUNCTION_KEYWORDS.contains(lcToken);
}

  result.append(token);
else if ( isNamedParameter(token) ) {
  result.append(token);

/**
 * Same functionality as {@link #renderWhereStringTemplate(String, String, Dialect, SQLFunctionRegistry)},
 * except that a SQLFunctionRegistry is not provided (i.e., only the dialect-defined functions are
 * considered).  This is only intended for use by the annotations project until the
 * many-to-many/map-key-from-target-table feature is pulled into core.
 *
 * @deprecated Only intended for annotations usage; use {@link #renderWhereStringTemplate(String, String, Dialect, SQLFunctionRegistry)} instead
 */
@Deprecated
@SuppressWarnings({ "JavaDoc" })
public static String renderWhereStringTemplate(String sqlWhereString, String placeholder, Dialect dialect) {
  return renderWhereStringTemplate(
      sqlWhereString,
      placeholder,
      dialect,
      new SQLFunctionRegistry( dialect, java.util.Collections.<String, SQLFunction>emptyMap() )
  );
}

hasOrder = sqlOrderByString != null;
sqlOrderByStringTemplate = hasOrder ?
    Template.renderOrderByStringTemplate(sqlOrderByString, dialect, factory.getSqlFunctionRegistry()) :
    null;
sqlWhereString = StringHelper.isNotEmpty( collection.getWhere() ) ? "( " + collection.getWhere() + ") " : null;
hasWhere = sqlWhereString != null;
sqlWhereStringTemplate = hasWhere ?
    Template.renderWhereStringTemplate(sqlWhereString, dialect, factory.getSqlFunctionRegistry()) :
    null;

private static boolean isFunctionOrKeyword(String lcToken, String nextToken, Dialect dialect, SQLFunctionRegistry functionRegistry) {
  return "(".equals(nextToken) ||
    KEYWORDS.contains(lcToken) ||
    isFunction(lcToken, nextToken, functionRegistry ) ||
    dialect.getKeywords().contains(lcToken) ||
    FUNCTION_KEYWORDS.contains(lcToken);
}

  final String field = extractUntil( tokens, "from" );
  final String source = renderWhereStringTemplate(
      extractUntil( tokens, ")" ),
      placeholder,
      dialect,
          renderWhereStringTemplate( trimOperands.trimSpec, placeholder, dialect, functionRegistry )
      );
  result.append( renderWhereStringTemplate( trimOperands.trimSource, placeholder, dialect, functionRegistry ) )
      .append( ')' );
else if ( isNamedParameter(token) ) {
  result.append(token);
else if ( isIdentifier(token, dialect)
    && !isFunctionOrKeyword(lcToken, nextToken, dialect , functionRegistry) ) {
  result.append(placeholder)
      .append('.')

protected static String getTemplateFromString(String string, SessionFactoryImplementor factory) {
  return string == null ?
      null :
      Template.renderWhereStringTemplate( string, factory.getDialect(), factory.getSqlFunctionRegistry() );
}

hasWhere = sqlWhereString != null;
sqlWhereStringTemplate = hasWhere ?
    Template.renderWhereStringTemplate( sqlWhereString, dialect, factory.getSqlFunctionRegistry() ) :
    null;
  sqlOrderByStringTemplate = Template.renderOrderByStringTemplate(
      collection.getOrderBy(),
      mapper,
manyToManyWhereTemplate = manyToManyWhereString == null ?
    null :
    Template.renderWhereStringTemplate( manyToManyWhereString, factory.getDialect(), factory.getSqlFunctionRegistry() );
  manyToManyOrderByTemplate = Template.renderOrderByStringTemplate(
      collection.getManyToManyOrdering(),
      mapper,

  public String doStandardRendering(String fragment) {
    return Template.renderOrderByStringTemplate( fragment, MAPPER, SESSION_FACTORY, DIALECT, FUNCTION_REGISTRY );
  }
}

private static boolean isFunctionOrKeyword(
    String lcToken,
    String nextToken,
    Dialect dialect,
    SqmFunctionRegistry functionRegistry) {
  return "(".equals( nextToken ) ||
      KEYWORDS.contains( lcToken ) ||
      isType( lcToken, dialect ) ||
      isFunction( lcToken, nextToken, functionRegistry ) ||
      dialect.getKeywords().contains( lcToken ) ||
      FUNCTION_KEYWORDS.contains( lcToken );
}

  final String field = extractUntil( tokens, "from" );
  final String source = renderWhereStringTemplate(
      extractUntil( tokens, ")" ),
      placeholder,
      dialect,
          renderWhereStringTemplate( trimOperands.trimSpec, placeholder, dialect, functionRegistry )
      );
  result.append( renderWhereStringTemplate( trimOperands.trimSource, placeholder, dialect, functionRegistry ) )
      .append( ')' );
else if ( isNamedParameter(token) ) {
  result.append(token);
else if ( isIdentifier(token, dialect)
    && !isFunctionOrKeyword(lcToken, nextToken, dialect , functionRegistry) ) {
  result.append(placeholder)
      .append('.')

@Override
public String getTemplate(Dialect dialect, SQLFunctionRegistry functionRegistry) {
  String template = Template.renderWhereStringTemplate(formula, dialect, functionRegistry);
  return safeInterning( StringHelper.replace( template, "{alias}", Template.TEMPLATE ) );
}

hasWhere = sqlWhereString != null;
sqlWhereStringTemplate = hasWhere ?
    Template.renderWhereStringTemplate( sqlWhereString, dialect, factory.getSqlFunctionRegistry() ) :
    null;
  sqlOrderByStringTemplate = Template.renderOrderByStringTemplate(
      collection.getOrderBy(),
      mapper,
manyToManyWhereTemplate = manyToManyWhereString == null ?
    null :
    Template.renderWhereStringTemplate( manyToManyWhereString, factory.getDialect(), factory.getSqlFunctionRegistry() );
  manyToManyOrderByTemplate = Template.renderOrderByStringTemplate(
      collection.getManyToManyOrdering(),
      mapper,