[ANKI Image File Rename] Extract the image resource, rename preserving the sort order #sql #anki

anki_image_renamer_json.sql

SELECT json_group_object(
               trim(file_name), sequence_id
           ) AS json_result
FROM (select t2.sfld as file_name, t1.due, row_number() over (order by t1.due) as sequence_id
      from cards t1
               inner join (
          select id, flds, sfld, mid
          from notes
      ) t2
                          on t1.nid = t2.id
      order by t1.due);