Skip to content

Instantly share code, notes, and snippets.

@MatMoore

MatMoore/concat.py

Created July 17, 2024 07:53
Show Gist options
  • Save MatMoore/620775b07b0cbeeb80c46928843eee2c to your computer and use it in GitHub Desktop.
Save MatMoore/620775b07b0cbeeb80c46928843eee2c to your computer and use it in GitHub Desktop.
Download ZIP
Long query examples
Raw
concat.py
expression = """
WITH T2 AS ( SELECT (
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') ||
coalesce('foo', 'bar') as varchar
) as baz
FROM T1 )
SELECT * FROM T2
"""
dialect = sqlglot.Dialect.get_or_raise("trino")
parsed_expression = sqlglot.maybe_parse(
expression, dialect=dialect, error_level=sqlglot.ErrorLevel.IMMEDIATE
).copy()
pretty = parsed_expression.sql(dialect=dialect, pretty=True)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment