Amazon Redshift

Redshift is a column-compressed database so full table scans on columns are possible without indexes.

Redshift interface is just SQL.