I didn't see this the first time:

    GROUP AND ORDER BY component_id DESC;

Is this kind of syntax combining grouping and ordering really necessary in addition the pipe operator? My advice would be to add the pipe operator and not get fancy adding other syntax to SQL as well.