[release-19.0] Fix aliasing in routes that have a derived table (#15550)

[release-19.0] Fix aliasing in routes that have a derived table (#15550) #28875