/ 
DBIO-0.900000
/ DBIO::Storage::QueryRewrite

NAME

DBIO::Storage::QueryRewrite - SQL analysis and query rewrite utilities

VERSION

version 0.900000

DESCRIPTION

SQL analysis and query rewrite helpers used by DBIO::Storage::DBI. Handles join pruning, complex prefetch subquery generation, and alias/column resolution.

METHODS

_prune_unused_joins

Remove non-selecting/non-restricting joins from {from} specs, aiding the RDBMS query optimizer.

_adjust_select_args_for_complex_prefetch

Produce joined subqueries for complex prefetches, e.g. SELECT me.*, other.* FROM ( SELECT me.* FROM ... ) JOIN other ON ...

_resolve_aliastypes_from_select_args

_group_over_selection

_minmax_operator_for_datatype

_resolve_ident_sources

_resolve_column_info

_inner_join_to_node

_find_join_path_to_node

_extract_order_criteria

_order_by_is_stable

_columns_comprise_identifying_set

_extract_colinfo_of_stable_main_source_order_by_portion

_collapse_cond

_collapse_cond_unroll_pairs

_extract_fixed_condition_columns

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.