jsons = spark.sql("""
SELECT '/mediawiki/page/late/1.0.0' AS `$schema`,
       c.comment_text AS comment,
       DATE_FORMAT(TO_TIMESTAMP(r.rev_timestamp, 'yyyyMMddkkmmss'), "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'") AS dt,
       NAMED_STRUCT(
           'namespace_id', p.page_namespace,
           'page_id', p.page_id,
           'page_title', p.page_title
       ) AS page,
       NAMED_STRUCT(
           'user_id', a.actor_id,  -- is it actor_id we want, or user_id?
           'user_text', a.actor_name
       ) AS performer,
       NAMED_STRUCT(
           'comment', c.comment_text,
           'content_slots', MAP(  -- FIXME: currently spitting one map per slot instead of one MAP with all slots
                                sr.role_name, NAMED_STRUCT(
                                                    'content_body', NULL,
                                                    'content_format', NULL,  -- not persisted in MariaDB!
                                                    'content_model', cm.model_name,
                                                    'content_sha1', ct.content_sha1,
                                                    'content_size', ct.content_size,
                                                    'origin_rev_id', r.rev_id,
                                                    'slot_role', sr.role_name
                                                )
                            ),
           'editor', NAMED_STRUCT(
                         'user_id', a.actor_id,  -- is it actor_id we want, or user_id?
                         'user_text', a.actor_name
                     ),
           'is_comment_visible', r.rev_deleted & 4 = 0,
           'is_content_visible', r.rev_deleted & 1 = 0,
           'is_editor_visible',  r.rev_deleted & 2 = 0,
           'is_minor_edit', CAST(r.rev_minor_edit AS BOOLEAN),
           'rev_dt', DATE_FORMAT(TO_TIMESTAMP(r.rev_timestamp, 'yyyyMMddkkmmss'), "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"),
           'rev_id', r.rev_id,
           'rev_parent_id', r.rev_parent_id,
           'rev_sha1', r.rev_sha1,
           'rev_size', r.rev_len
       ) as revision,
       'etwiki' AS wiki_id
FROM wmf_raw.mediawiki_revision r
INNER JOIN wmf_raw.mediawiki_private_comment c ON r.rev_comment_id = c.comment_id
INNER JOIN wmf_raw.mediawiki_page p ON r.rev_page = p.page_id
INNER JOIN wmf_raw.mediawiki_private_actor a ON r.rev_actor = a.actor_id
INNER JOIN wmf_raw.mediawiki_slots s ON r.rev_id = s.slot_revision_id
INNER JOIN wmf_raw.mediawiki_slot_roles sr ON s.slot_role_id = sr.role_id
INNER JOIN wmf_raw.mediawiki_content ct ON s.slot_content_id = ct.content_id
INNER JOIN wmf_raw.mediawiki_content_models cm ON ct.content_model = cm.model_id

WHERE r.snapshot = '2024-08'
  AND r.wiki_db = 'etwiki'
  
  AND c.snapshot = '2024-08'
  AND c.wiki_db = 'etwiki'
  
  AND p.snapshot = '2024-08'
  AND p.wiki_db = 'etwiki'
  
  AND a.snapshot = '2024-08'
  AND a.wiki_db = 'etwiki'

  AND s.snapshot = '2024-08'
  AND s.wiki_db = 'etwiki'

  AND sr.snapshot = '2024-08'
  AND sr.wiki_db = 'etwiki'

  AND ct.snapshot = '2024-08'
  AND ct.wiki_db = 'etwiki'
  
  AND cm.snapshot = '2024-08'
  AND cm.wiki_db = 'etwiki'
LIMIT 10
""").toJSON().collect()

{
    "$schema": "/mediawiki/page/late/1.0.0",
    "comment": "\u00dcmbersuunamine lehele [[Hiie p\u00f5der]]",
    "dt": "2018-08-02T07:41:19.000Z",
    "page": {
        "namespace_id": 0,
        "page_id": 517279,
        "page_title": "Hiie_hirv"
    },
    "performer": {
        "user_id": 2108,
        "user_text": "Estopedist1"
    },
    "revision": {
        "comment": "\u00dcmbersuunamine lehele [[Hiie p\u00f5der]]",
        "content_slots": {
            "main": {
                "content_model": "wikitext",
                "content_sha1": "e1kgga2lh5n2kqzmnlgl5ersavrskcb",
                "content_size": 22,
                "origin_rev_id": 5063002,
                "slot_role": "main"
            }
        },
        "editor": {
            "user_id": 2108,
            "user_text": "Estopedist1"
        },
        "is_comment_visible": true,
        "is_content_visible": true,
        "is_editor_visible": true,
        "is_minor_edit": false,
        "rev_dt": "2018-08-02T07:41:19.000Z",
        "rev_id": 5063002,
        "rev_parent_id": 0,
        "rev_sha1": "e1kgga2lh5n2kqzmnlgl5ersavrskcb",
        "rev_size": 22
    },
    "wiki_id": "etwiki"
}

https://www.mediawiki.org/w/api.php?action=query&prop=revisions&titles=MediaWiki&rvlimit=5&rvprop=timestamp%7Cuser%7Ccomment%7Ccontentmodel%7Ccontent&rvslots=*

{
    "continue": {
        "rvcontinue": "20191003091610|3439858",
        "continue": "||"
    },
    "query": {
        "pages": {
            "1": {
                "pageid": 1,
                "ns": 0,
                "title": "MediaWiki",
                "revisions": [
                    {
                        "user": "Tropicalkitty",
                        "timestamp": "2023-12-29T18:14:25Z",
                        "slots": {
                            "main": {
                                "contentmodel": "wikitext",
                                "contentformat": "text/x-wiki",
                                "*": "{{Main page|{{zh other|zh|{{#ifexist:Template:Main page/{{int:lang}}|{{int:lang}}|en}}}}}}{{NOEXTERNALLANGLINKS}}<!--\n-- To edit what appears on this page,\n-- please see [[Template:Main_page]] \n-- https://www.mediawiki.org/wiki/Template:Main_page\n-->"
                            }
                        },
                        "comment": "Requested at [[Topic:Xw9xzifnfeunzvnn]]"
                    },
...