They give you an example on that page by using WP_Query to query for all pages, then get_page_children just filters that list. the “without using SQL queries” part is a bit of a misnomer, since you have to have already queried the database at some point to get those pages. if you don’t already have a result to filter, then something like get_children or get_pages might be simpler.
