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

The Summer of Johann: prompt injections as far as the eye can see - 15th August 2025
Open weight LLMs exhibit inconsistent performance across providers - 15th August 2025
LLM 0.27, the annotated release notes: GPT-5 and improved tool calling - 11th August 2025

django 576 michael-trier 4 orm 40 python 1176 sql 103

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