seems like there’s an issue with case 3. the person_id and from surveillance_records doesn’t match up with the person_id in the hotel_checkins table when joined on hotel-checkin_id

haaave you heard about our lord and saviour Typst?

same layout algorithm as LaTeX, but:

• simpler markup
• sane, consistent scripting language
• fast compilation, including incremental updates so you can have a process watching your file and instantly create a new PDF on changes
• easy collaborative editing through their web app
• actually understandable error messages