Using raw sql in django python

Question

I have few things to ask for custom queries in Django

DO i need to use the DB table name in the query or just the Model name
if i need to join the various tables in raw sql. do i need to use db field name or model field name like

Person.objects.raw('SELECT id, first_name, last_name, birth_date FROM Person A inner join Address B on A.address = B.id ')

or B.id = A.address_id

Jamey Sharp · Accepted Answer · 2012-11-01 06:58:03Z

3

You need to use the database's table and field names in the raw query--the string you provide will be passed to the database, not interpreted by the Django ORM.

answered Nov 1, 2012 at 6:58

Jamey Sharp

8,5322 gold badges33 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using raw sql in django python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related