The Perl Advent Calendar needs more articles for 2022. Submit your idea today!

Changes for version 0.7 - 2022-11-20

  • Fix missing ORDER BY clause in aggregates
  • Fix missing "WITH ORDINALITY" clause in functions in FROM
  • Make sure that "bugs" test try also to test as_text() calls

Documentation

Class representing single parameter reference ($1)
Class representing subselect within FROM

Modules

Pretty printing SQL queries
Base class for all elements of query parse tree.
Class representing ARRAY[...] expression
Class representing single constant value
Class representing expression (two values and operator, or operator and single value)
Class representing single "indirection" indexes - column[THIS:HERE]
Class representing "indirection" - access to element(s) of array.
Class representing * expression
Class representing bitstring: B'010101'
Class representing boolean expression
Class representing expression like 'x IS TRUE'
Class representing CASE expression
Class representing single CASE WHEN element
Class representing COALESCE(...) expression
Class representing COLLATE clause
Class representing single type cast operation
Class representing single CTE
Class representing single param definition, for example "ANALYZE ON" for explains..
Class representing DELETE FROM query
Class representing EXPLAIN query
Class representing single float value
Class representing single constant value
Class representing GROUPING(...) expression
Class representing grouping set - that is GROUP BY with either "GROUPING SET", "ROLLUP", or "CUBE"
Class representing single element of index, basically column/expression with ordering info
Class representing insert statement
Class representing single integer value
Class representing join between two "tables"
Class representing list of values
Class representing locking clause of SELECT
Class representing GREATEST() or LEAST() expression
Class representing multi-column assignment
Class representing single named argument to a function
Class representing single NULL
Class representing NULL comparison
Class representing "RangeFunction" (functions returning recordset)
Class representing TABLESAMPLE expression
Class representing "RangeVar" (source of data)
Class representing result target (column)
Class representing Row Expression, like (a, b, c)
Class representing SQL-Value
Class representing single select statement
Class representing DEFAULT clause for writes.
Class representing single ORDER BY element
Class representing single integer value
Class representing subquery
Class representing transaction start or end statements.
Class representing single type cast operation
Class representing UPDATE statement
Class representing xmlelement
Class representing XMLSERIALIZE() expression

Provides

in lib/Pg/SQL/PrettyPrinter/Node/ParamRef.pm
in lib/Pg/SQL/PrettyPrinter/Node/RangeSubselect.pm