update object_type set location = 'new floor' where id in ( with recursive tree (child) as ( values(cast(100 as bigint)) union select ot.id from object_type ot, tree where ot.parent_id = child and ot.direct_location = false) select child from tree)

<named-native-query name="ObjectType.updateLocation">
  <query>
    <![CDATA[
      update object_type set location = :location where id in (
        with recursive tree (child) as (
          values(:parent_id)
          union
          select ot.id from object_type ot, tree where ot.parent_id = child and ot.direct_location = false)
        select child from tree)
    ]]>
  </query>
</named-native-query>