django sql query example

Example 1: django 3.0 queryset examples

>>> Entry.objects.filter(
...     headline__startswith='What'
... ).exclude(
...     pub_date__gte=datetime.date.today()
... ).filter(
...     pub_date__gte=datetime.date(2005, 1, 30)
... )

Example 2: django swlite queries

>>> Entry.objects.filter(pub_date__lte='2006-01-01')