I have a table which has columns:
I want a query that produces two rows for each source row. The output would look like:
focal_user_id value is generated from
from_user_id for the first row output, and generated from
to_user_id for the second row.
I need to do this in SQL rather than code because then I can make use of
LIMIT, as well as do some joins based on the new