com.jn.sqlhelper.dialect.internal.SnowflakeDialect Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of sqlhelper-dialect Show documentation

Database dialects ( supports pagination, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java, you can use it in any ORM framework.

There is a newer version: 5.0.7

Show newest version

package com.jn.sqlhelper.dialect.internal;

import com.jn.sqlhelper.dialect.internal.limit.OffsetFetchFirstOnlyLimitHandler;

/**
 * https://docs.snowflake.net/manuals/sql-reference/constructs/limit.html
 * 
 * support two limit syntax:
 * SELECT ...
 * FROM ...
 * [ ORDER BY ... ]
 * LIMIT  [ OFFSET  ]
 * [ ... ]
 * 
 * -- ANSI syntax
 * SELECT ...
 * FROM ...
 * [ ORDER BY ... ]
 * [ OFFSET  ] [ { ROW | ROWS } ] FETCH [ { FIRST | NEXT } ]  [ { ROW | ROWS } ] [ ONLY ]
 * [ ... ]
 */
public class SnowflakeDialect extends AbstractDialect {
    public SnowflakeDialect() {
        super();
        setLimitHandler(new OffsetFetchFirstOnlyLimitHandler());
    }


    @Override
    public boolean isSupportsLimitOffset() {
        return true;
    }
}