After further investigation it looks like with more complex table structures even "select * from table" will give an error.