query-builder

Diesel currently supports the postgres json and jsonb types. We do not provide built-in support for various operators available for these types. This is a tracking issue for adding support for these operators.

The general strategy for adding support for new operators is as following:

1. Define the operator via [`infix_operator!(

For eg. '==' tooltip as "Equals", 'Like' tooltip as "Contains", etc

It would be nice if there was a new clause which can be added to queries called callback.

For example:

def callback_handler(success, value):
    if success:
        print(f'The query was successful and returned {value}')
    else:
        print("The query failed")

Band.select().callback(callback_handler).run_sync()

The callback could be a function or coroutine, wh

The .returning() function currently only supports strings (which should be the target table's column names). In reality they can accept any expression and (returning) query.

This should be supported:

insert into bar (val) values (123) returning (select count(*) from bar), id, val || 'test'

which would equate to something like:

db.insertInto(bar).values({ val: 123 })

Summary

CREATE TABLE example (
    values text[]
)

If I want to check if a value is in values, this is how i would write the SQL "raw".

SELECT values 
FROM example 
WHERE "boop" = any(values);

I looked around but didn't see a native way to express this. I ended up doing this instead:

Query:select()
.cond_where(
    Expr::cust