select
    'hibernate_sequence_1' as sequence_name,
    minimum_value,
    maximum_value,
    start_value,
    increment,
    cache_size
from
    hibernate_sequence_1
union all
select
    'hibernate_sequence' as sequence_name,
    minimum_value,
    maximum_value,
    start_value,
    increment,
    cache_size
from
    hibernate_sequence

	@Override
	public Iterable<SequenceInformation> extractMetadata(ExtractionContext extractionContext) throws SQLException {
		final String lookupSql = extractionContext.getJdbcEnvironment().getDialect().getQuerySequencesString();

		// *should* never happen, but to be safe in the interest of performance...
		if (lookupSql == null) {
			return SequenceInformationExtractorNoOpImpl.INSTANCE.extractMetadata(extractionContext);
		}

		final IdentifierHelper identifierHelper = extractionContext.getJdbcEnvironment().getIdentifierHelper();

		final List<SequenceInformation> sequenceInformationList = new ArrayList<>();
		final List<String> sequenceNames = new ArrayList<>();

		try (
				final Statement statement = extractionContext.getJdbcConnection().createStatement();
				final ResultSet resultSet = statement.executeQuery( lookupSql );
		) {
			while ( resultSet.next() ) {
				sequenceNames.add( resultSetSequenceName( resultSet ) );
			}
		}

		if ( !sequenceNames.isEmpty() ) {
			StringBuilder sequenceInfoQueryBuilder = new StringBuilder();

			for ( String sequenceName : sequenceNames ) {
				if ( sequenceInfoQueryBuilder.length() > 0 ) {
					sequenceInfoQueryBuilder.append( UNION_ALL );
				}
				sequenceInfoQueryBuilder.append( String.format( SQL_SEQUENCE_QUERY, sequenceName ) );
			}

			int index = 0;

			try (
					final Statement statement = extractionContext.getJdbcConnection().createStatement();
					final ResultSet resultSet = statement.executeQuery( sequenceInfoQueryBuilder.toString() );
			) {

				while ( resultSet.next() ) {

					SequenceInformation sequenceInformation = new SequenceInformationImpl(
						new QualifiedSequenceName(
								null,
								null,
								identifierHelper.toIdentifier(
										resultSetSequenceName(resultSet)
								)
						),
						resultSetStartValueSize(resultSet),
						resultSetMinValue(resultSet),
						resultSetMaxValue(resultSet),
						resultSetIncrementValue(resultSet)
					);

					sequenceInformationList.add(sequenceInformation);
				}

			}
		}

		return sequenceInformationList;
	}