Aura.SqlQuery

Aura.SqlQuery copied to clipboard

Quoting problem with cast() on postgres

2

I'm on postgres and am writing a select that converts an integer field to varchar, so I can compare using "like". The 2.x branch misquotes the cast structure's datatype. ```php

inghamn

Named placeholder don't work in where()

1

The documentation in examles allow to used named placeholders in where clause like this: ``` // bind 'zim_val' to the :zim placeholder ->where('zim = :zim', ['zim' => 'zim_val']) ``` But...

gugglegum

Go back to pseudo-sequential where() and having() placeholders?

10

Hi all, esp. @pavarnos -- Earlier, we removed ?-placeholder replacements from where(), having(), etc., and replaced it with binding of named parameters as part of the method call. So, in...

pmjones

how to execute a query using: USE INDEX?

1

SELECT * FROM table1 USE INDEX (col1_index,col2_index)

suvarivaza

It would be convenient to be able to pass a query directly to `union()` instead of rerunning the same commands on the original query. Here's what I thought I would...

RentecTravis

Add lateral joins

2

Postgresql supports lateral joins but they currently cannot be used. This makes it possible.

golgote

Postgres Lateral Join

2

It would be nice if we could use new PostgreSQL lateral join. Any way to do it so far?

dextervip

Maybe I'm missing something... How would I replicate the following? ``` where ( find_in_set(tests.`compound.group`, :compound_groups) or find_in_set(tests.`compound.name`, :compound_names) ) and ( find_in_set(isolates.`species.genus`, :species_genera) or find_in_set(isolates.`species.name`, :species_names) ) ``` The parentheses...

designermonkey

Improve IN statement for 3.0 release

8

Hello, I think we can improve the IN statement for 3.0 release. Maybe allow this syntax : ` $query->where('user_Id IN (?)', [1, 2, 3, 4, 5]); ` And the builder...

syrm

Update '->where' method with binding params don't working

2

Hi, everyone. Method 'where' with passed two params don't working for me. I do that `->where('gir = :gir', ['gir' => 'gir_val'])` Also phpstorm shows warning with the text: > Method...

FAST-JE