In a join, how to prefix all column names with the table it came from

You could

select ah.*, l.*, u.*, pi.* from ...

then the columns will be returned ordered by table at least.

For better distinction between every two sets of columns, you could also add “delimiter” columns like this:

select ah.*, ':', l.*, ':', u.*, ':', pi.* from ...

^{(Edited to remove explicit aliases as unnecessary, see comments.)}