Added support for where, order, limit and offset.