> On Feb 21, 2022, at 9:50 AM, Mike Bayer wrote:
>
> I thought 1.3 had "values", but if not, then you'd need to roll a recipe of
> some kind, the original recipe is at
> https://github.com/sqlalchemy/sqlalchemy/wiki/PGValues
Thanks. In 1.3 sqlalchemy.sql.expression.ValuesBase exists,
I thought 1.3 had "values", but if not, then you'd need to roll a recipe of
some kind, the original recipe is at
https://github.com/sqlalchemy/sqlalchemy/wiki/PGValues
On Mon, Feb 21, 2022, at 9:06 AM, Philip Semanchuk wrote:
> Thanks! It looks like 1.4 is required for this, correct? Any way
Thanks! It looks like 1.4 is required for this, correct? Any way to do this
under 1.3?
> On Feb 20, 2022, at 8:17 PM, Mike Bayer wrote:
>
> the Values construct doesn't have CTE direct support right now so you need to
> make a subquery first, then CTE from that
>
> from sqlalchemy import
the Values construct doesn't have CTE direct support right now so you need to
make a subquery first, then CTE from that
from sqlalchemy import Column
from sqlalchemy import column
from sqlalchemy import Integer
from sqlalchemy import select
from sqlalchemy import String
from sqlalchemy import
Hi,
I'm trying to use a VALUES statement in a CTE, and I can't figure out the
correct SQLAlchemy constructs to make this happen. I'd appreciate any help.
Here's the SQL I'd like to express in SQLAlchemy --
WITH knights(name, favorite_color) AS (
VALUES
('Lancelot', 'blue'),