A nitpick: select doesn't declare fields for where. select declare fields for having. it's the schema that declares fields that can be used in where.