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.