Raw SQL, SQL Query Builder, or ORM?

Channel Avatar
Raw SQL, SQL Query Builder, or ORM?
Raw SQL, SQL Query Builder, or ORM?
Not sure if you should use Raw SQL, a SQL query builder, or an ORM for your next project? In this video, I’ll explore the pros and cons of each option, allowing you to make an informed decision based on your specific needs. Choosing the wrong technology for your project can be a costly mistake, so it’s crucial to understand these tools.

Code example on GitHub: https://github.com/ArjanCodes/2023-orm

Take a quiz on this topic: https://www.learntail.com/quiz/syflxl

Next-Level Python Skillshare Class: https://skl.sh/3ZQkUEN

Join the FREE Code Diagnosis Workshop to help you review code more effectively using my 3-Factor Diagnosis Framework: https://www.arjancodes.com/diagnosis

ArjanCodes Blog: https://www.arjancodes.com/blog

The Software Designer Mindset: https://www.arjancodes.com/mindset
The Software Designer Mindset Team Packages: https://www.arjancodes.com/sas
The Software Architect Mindset: Pre-register now! https://www.arjancodes.com/architect
Next Level Python: Become a Python Expert: https://www.arjancodes.com/next-level-python
The 30-Day Design Challenge: https://www.arjancodes.com/30ddc

GEAR & RECOMMENDED BOOKS: https://kit.co/arjancodes. If you enjoyed this content, give this video a like. If you want to watch more of my upcoming videos, consider subscribing to my channel!

Discord: https://discord.arjan.codes
Twitter: https://twitter.com/arjancodes
LinkedIn: https://www.linkedin.com/company/arjancodes
Facebook: https://www.facebook.com/arjancodes
Instagram: https://www.instagram.com/arjancodes
Tiktok: https://www.tiktok.com/@arjancodes

Code reviewers:
– Yoriz
– Ryan Laursen
– James Dooley
– Dale Hagglund

Video edited by Mark Bacskai: https://www.instagram.com/bacskaimark
Code example by Henrique Branco: https://www.linkedin.com/in/henriqueajnb

0:00 Intro
1:18 Code example
2:09 Main options
2:44 raw SQL
7:12 ORM
12:49 SQL query builder
14:30 Final thoughts
16:01 Outro

#arjancodes #softwaredesign #python

DISCLAIMER – The links in this description might be affiliate links. If you purchase a product or service through one of those links, I may receive a small commission. There is no additional charge to you. Thanks for supporting my channel so I can continue to provide you with free content each week!

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: sql query, sql, sql vs orm, object relational mapping or structured query language, object relational mapping or SQL, object relational mapping vs SQL, what is orm, orm vs sql, orm or sql, object relational mapping, orm, query builder, sql tutorial, sql query optimization, sql query tutorial, django sql, database query, database query using sql, build queries, query python, sqlalchemy, sqlalchemy python, sqlalchemy tutorial, sqlalchemy vscode, sqlalchemy tutorial python

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *