Restrict Relational Operators to the appropriate DML

[calvinlfer]

I still need to do some more research on this but it seems like certain relations in WHERE clauses are not allowed for UPDATE vs SELECT statements. Initially, I was thinking of doing it like the following:

final case class Relation[A: Writer, Operator <: RelationOperator](
  columnName: ColumnName,
  operator: Operator,
  value: A
)

sealed trait RelationOperator
object RelationOperator {
  sealed trait DeleteRelationOperator extends RelationOperator
  sealed trait UpdateRelationOperator extends RelationOperator

  case object Equal              extends RelationOperator with UpdateRelationOperator with DeleteRelationOperator
  case object NotEqual           extends RelationOperator with UpdateRelationOperator
  case object GreaterThan        extends RelationOperator with UpdateRelationOperator
  case object GreaterThanOrEqual extends RelationOperator with UpdateRelationOperator
  case object LessThan           extends RelationOperator with UpdateRelationOperator
  case object LessThanOrEqual    extends RelationOperator with UpdateRelationOperator
  case object Like               extends RelationOperator
  case object In                 extends RelationOperator with DeleteRelationOperator
}

Then in the Update query builder, we can restrict inputs to use Relation[ScalaType, UpdateRelationOperator]

[FrancisToth]

I can help on this.

[calvinlfer]

We'll need to go through the Cassandra documentation and figure out what is possible in certain queries