Skip to main content

Module canonicalize

Module canonicalize 

Source
Expand description

Canonicalization of SQL expressions into standard form Canonicalization Module

This module provides functionality for converting SQL expressions into a standard canonical form. This includes:

  • Converting string addition to CONCAT
  • Replacing date functions with casts
  • Removing redundant type casts
  • Ensuring boolean predicates
  • Removing unnecessary ASC from ORDER BY

Ported from sqlglot’s optimizer/canonicalize.py

Functions§

canonicalize
Converts a SQL expression into a standard canonical form.