.. index:: pair: query ; QuerySet .. _django_sql_tips_3: ============================================================== Utilisation de **QuerySet.query** (str(query)) ============================================================== .. seealso:: - https://docs.djangoproject.com/en/dev/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running - :ref:`sqlparse` Example ======== :: In [43]: query = LogDocument.objects.filter(logdate__year=2020).query In [44]: query Out[44]: In [45]: str(query) Out[45]: 'SELECT `log_document`.`id`, `log_document`.`logdate`, `log_document`.`id_etude_notariale`, `log_document`.`agence_id`, `log_document`.`type_doc`, `log_document`.`status_doc`, `log_document`.`formality_type` FROM `log_document` WHERE `log_document`.`logdate` BETWEEN 2020-01-01 00:00:00 AND 2020-12-31 23:59:59.999999 ORDER BY `log_document`.`logdate` DESC' You can use :ref:`sqlparse ` to have a clean SQL command.