데이터 탐색기의 10,000개 결과 제한을 우회하는 방법?

[JammyDodger]

For larger queries, you can add pagination to them and get batches that can be merged together ‘off-site’. Something like:

--[params]
-- integer :limit = 10000
-- integer :page = 0

SELECT
    id,
    title
FROM topics
WHERE visible = false
ORDER BY id
OFFSET :page * :limit
LIMIT :limit