Simon Willison’s Weblog

Finding Lookup Items that Are Not Used. How to do left outer joins (and other custom SQL) using the Django ORM.

Posted 13th August 2007 at 5:08 pm

Recent articles

Nano Banana Pro aka gemini-3-pro-image-preview is the best available image generation model - 20th November 2025
How I automate my Substack newsletter with content from my blog - 19th November 2025
Trying out Gemini 3 Pro with audio transcription and a new pelican benchmark - 18th November 2025

django 578 michael-trier 4 orm 40 python 1206 sql 107

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe