# Query Builder support

You can always use raw queries for interaction with range tipes like so:

$query->whereRaw('range_column && ?::daterange', [$range]);

All Range objects will be correctly casted to strings

But for convenience this package provides a number of useful macros for query builder:

WARNING

Use with caution!

Parameters that passed to these macros are not validated and potentially are vulnerable to SQL injections.

Be sure to pass only validated data to these methods!

If you know a way how to use these operators with PDO and proper typecasting, you are very welcome to contribute.

Macro	Postgres operator
`whereRangeContains($left, $right)`	@>
`orWhereRangeContains($left, $right)`	@>
`whereRangeIsContainedBy($left, $right)`	<@
`orWhereRangeIsContainedBy($left, $right)`	<@
`whereRangeOverlaps($left, $right)`	&&
`orWhereRangeOverlaps($left, $right)`	&&
`whereRangeStrictlyLeftOf($left, $right)`	<<
`orWhereRangeStrictlyLeftOf($left, $right)`	<<
`whereRangeStrictlyRightOf($left, $right)`	>>
`orWhereRangeStrictlyRightOf($left, $right)`	>>
`whereRangeDoesNotExtendToTheRightOf($left, $right)`	&<
`orWhereRangeDoesNotExtendToTheRightOf($left, $right)`	&<
`whereRangeDoesNotExtendToTheLeftOf($left, $right)`	&>
`orWhereRangeDoesNotExtendToTheLeftOf($left, $right)`	&>
`whereRangeAdjacentTo($left, $right)`	-\|-
`orWhereRangeAdjacentTo($left, $right)`	-\|-