class Multiwoven::Integrations::Source::WatsonxData::Client

def batched_query_for_presto(query, limit, offset)
  <<~SQL
    SELECT * FROM (
      SELECT *, ROW_NUMBER() OVER () as rownum FROM ( #{query} ) subquery
    ) t
    WHERE rownum > #{offset}
    LIMIT #{limit}
  SQL
end