Improve cross-DB discovery for edge conditions

What does this MR do and why?

This is taken from: !74735 (closed).

It contains the following changes that improve a way how we discover cross-modification:

• Extend in_factory_bot_create? to discover validations
• Add QueryAnalyzerError based on Exception to raise in tests
• Raise exception on misaligned transaction
• Ensure that transaction boundaries are always parsed to properly support non-materialized transactions

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.