query returning defines columns

[Shaun-Hirst]

is it possible to do a query that does not return all the columns.

i've tried using with_entities
query = SiteAddress.query.with_entities(
SiteAddress.account_code.label('account_code'), SiteAddress.site_id.label('site_id'),
SiteAddress.site_name.label('site_name'), SiteAddress.is_default.label('is_default'))
sites = query.filter(SiteAddress.account_code == account_code).all()

and load_only
sites = SiteAddress.query.options(load_only(
'account_code', 'site_id', 'site_name', 'is_default')).filter(SiteAddress.account_code == account_code).all()

but i either get all the columns for they don't return as a tuple so i'm not able to map them to the model