Django bypass ORM! - Performing raw SQL queries without the ORM

The Django ORM series covers a range of common functions that you will perform on a database with Django. In this tutorial we introduce the idea of running your own SQL queries, thus bypassing the Django ORM features. This is an introductory guide to help you get start with the general concepts and structure of building SQL queries outside of the Django ORM.

00:00 Introduction

Code Repository 8

✨ Support us - join us as a very academy member

👍SUBSCRIBE to get more free tutorials, courses and code snippets!

👍👍Follow us on Facebook

👍👍👍Follow use on Twitter:

[mariansdj]

Finally, someone who explained it clearly !!! The only missing point that I would like to see is to use a diferent dB apart from the default sqlite. I mean, it would be great if you can show who to do this exact same procedure using a mysql separate database installed on the host. Thanks again !!!

[muntasirmahmud]

You are doing some amazing work....giving us details about Django....I am pretty sure that eventually you will get a lot of subscribers....take love❤️

[dota-plays-shorts]

i just finish the whole playlist it gave me a good understanding of ORM and databases in django
thank alot sir for your effort

[steveclouds]

Also i am deploying a project in machine learning with little knowledge, in django, however am feeling very obsessed to learning teh language

[garethjones]

Hi, what’s your recommendation between utilising orm or sql?

I have an sql background so that’s a lot more natural to me, especially when you want to query more than one table in a relational database than the orm model.

I’m also concerned around sql injection, using the raw method but appreciate you can pass in the parameters using %s but would it be best to use orm or can raw be safe if used properly?

Many thanks Gareth

[alibouzena]

is using django ORM or raw queries like this will give us the same data structure ?

[baibarsbarbarossa]

How does connection.cursor() know which database to connect?what get it to know?adapter?

[this.namanjain]

sir i have an query, how can we create a table without using model layer in django . i render on many pages but i am not able to get the write solutions . i am making a basic CRUD api in which i don't have to use model payer in that and just inject basic CRUD query in that without models . can you please guide me in this . any open suggestion ?

[budi]

Hi thanks. Using this way we can call stored proc as well, right ?

[manishranjan]

Hey, appreciate your work. Is there anything about sqlalchemy in recent future?

[kamleshmahadule]

Hi, how to execute query inside templates

[rakeshroy]

can any one help me how to convert raw query to ORM?