Log cross-DB join queries in production and development

Extracted from #341783 (closed)

This work is already started in !71540 (closed)