with recursive whole_bike as (
  select * from bicycle_parts
  where name = 'whole bicycle'
  union
  select part.*
  from whole_bike, part
  where
    whole_bike.id=part.part_of
)