Jsonb Selectors

[rainerborene]

@rzane what do you think about supporting jsonb selectors?
https://www.postgresql.org/docs/9.4/static/functions-json.html

Some ideias:

select data->>'completed_at' ...

which translates to

scope.selecting { data.completed_at }

Related discussions:
rails/arel#288

[rainerborene]

I'll be using this monkey patch until not having this feature implemented.

BabySqueel::Operators::Generic.module_eval do
  def json(name)
    op '->>', Arel::Nodes.build_quoted(name)
  end
end

# now i can do this
Activity.selecting { data.json(:name).eq('xzy') }

[rzane]

Great idea, but, I'd rather have a separate package implement JSON types and simply integrate it here. That way, users who don't use BabySqueel could reap the benefits as well. Does that make sense?

Related: rails/arel#288