How can I query for all children posts regardless of parent

Couple of possible ways.

  1. Use get_pages() with parent => 0 to fetch top-level ones and put them as post__not_in in query.

  2. Filter posts_where to add AND post_parent > 0 when necessary.