How to Write SQLAlchemy 2.0-Style Queries in Flask-SQLAlchemy

In this video I will go over the new style of queries that SQLAlchemy supports and recommends. I give examples in the context of a Flask-SQLAlchemy app.

[lgdd]

I too would love to see a video on how the new model definitions are done. Also, I'm enjoying and appreciating your videos. Thanks

[amarmusovic]

Seems like a huge step back on the whole "user friendliness" front, but I'm sure they had their reasons... We won't shoot the messenger, though. 😅Thanks a lot, great stuff, as always...

[damian-duffy]

Video on the new model definitions would be great. Particularly how different types of relationships are now defined.

[Itsyaboi]

Perfect timing! Please keep ‘em coming!

[samiam.]

Great video! I still think the legacy query system is easier to use. I'll keep working on the learning the new style, and might eventually switch just because that seems to be their preferred way, but that'll probably be down the road.

Also thanks for mentioning there is a new modeling system too, because I'm pretty unaware of it! So that'll be another thing on my to-do list lol

[amine]

The new way of doing things is closer to raw sql, its not that bad

[ylynfatt]

I prefer the old style, but I have been teaching my students both so they are aware of both styles. They can then choose the one they prefer to use.

[alikorloo]

11 months have passed and still no sign of a video for the new style of model creation!

[teprox]

Are there any advantages with the new syntax? For me it looks more complicated. and the approach of sqlalchemy was to make it simpler.

[chriskeo]

How do you check if temp tables exist?

Has_tables just does not work anymore

[vaneakatok]

hi Anthony

do you have any GraphQL content in the pipe?

[farzadmf]

Sorry for the naive question, but what's the advantage of this "new" API. From an "outsider" view, it just seems more complicated; is it providing any benefit given its weird and more complex syntax?

[MasonGelosotech]

This feels weird to me. Almost unnecessarily verbose. I feel like it was fine the way it was? Am I missing something, is it more performant? Or perhaps more modular/extendable in some way?

What an odd move by the maintainers.

[eboyd]

Why type so much! The old style is a bit more intuitive without needing to study what the code is doing.

[sibow]

😵‍💫😵‍💫😵‍💫 Talk about not being beginner friendly