Can I use lambda to create a query in SQLAlchemy?

Question

I need to implement a function that takes a lambda as the argument and queries the database. I use SQLAlchemy for ORM. Is there a way to pass the lambda, that my function receives, to SQLAlchemy to create a query?

Sincerely, Roman Prykhodchenko

Could you provide example of desired result? Its not too clear from the question itself. — Daniel Kluev
– Daniel Kluev, Commented Dec 17, 2010 at 13:38

Jochen Ritzel · Accepted Answer · 2010-12-17 13:33:19Z

2

I guess you want to filter the data with the lambda, like a WHERE clause? Well, no, functions nor lambdas cannot be turned into a SQL query. Sure, you could just fetch all the data and filter it in Python, but that completely defeats the purpose of the database.

You'll need to recreate the logic you put into the lambda with SQLAlchemy.

answered Dec 17, 2010 at 13:33

Jochen Ritzel

108k33 gold badges205 silver badges195 bronze badges

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

1 Comment

Roman Prykhodchenko Over a year ago

Thank you for your answer. Yes, I did want to filter results with the lambda.

Collectives™ on Stack Overflow

Can I use lambda to create a query in SQLAlchemy?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related