undefined | Better HN

0 pointsMichaelCollins3y ago0 comments

This sort of thing can be very good in the right hands, but it also facilitates the antipattern of select * with no conditions, then doing the real selection of columns and filtering of rows in code.

0 comments

JodieBenitez3y ago

There is no point in selecting columns here since what we want is objects, complete with all their properties. As for the rows, of course you can filter in your SQL:

    Person.objects.raw('SELECT * FROM myapp_person WHERE last_name = %s', ["Doe"])

Should you want to work without your models... well, you still have access to your connection object and can happily fetch whatever column or aggregate you want.

j / k navigate · click thread line to collapse

0 pointsMichaelCollins3y ago0 comments

This sort of thing can be very good in the right hands, but it also facilitates the antipattern of select * with no conditions, then doing the real selection of columns and filtering of rows in code.

0 comments

JodieBenitez3y ago

There is no point in selecting columns here since what we want is objects, complete with all their properties. As for the rows, of course you can filter in your SQL:

    Person.objects.raw('SELECT * FROM myapp_person WHERE last_name = %s', ["Doe"])

Should you want to work without your models... well, you still have access to your connection object and can happily fetch whatever column or aggregate you want.

j / k navigate · click thread line to collapse