Small script to extract apple notes files from the source sqlite3 file. Files extracted to their compressed files. Output is a protobuf doc. For simple notes the text is typically usable.

extract_notes.py

import sqlite3
import zipfile

con = sqlite3.connect("NoteStore.sqlite")
res = con.execute("select Z_PK, ZDATA from ZICNOTEDATA")
for row in res.fetchall():
  print(f"ID: {row[0]}")
  # this is a protobuf doc but the text is usually readable
  temp_file_name = f"doc{row[0]}.txt.zip"
  f = open(temp_file_name, "wb")
  f.write(row[1])
  f.close()