latitude

latitude copied to clipboard

Is there a way to name the binding parameters?

2

Hello, I use your library to generate sql for Clickhouse server. I cannot use question mark because the Clickhouse php library doesn't support them. Is there any way to name...

bmovi

Add subSelect() helper function

6

See https://github.com/shadowhand/latitude/issues/37#issuecomment-651809904

pavarnos

Make all query building methods append-only

2

Refer to changes make in #58; the following methods should be modified: - Merge functionality of `addColumns()` into `columns()` - Merge functionality of `addFrom()` into `from()`

shadowhand

ORDER BY case

2

I'm looking to do something similar to this... https://stackoverflow.com/questions/6332043/sql-order-by-multiple-values-in-specific-order Where I already know the specific order to apply before creating the query. In raw sql this would be written like...

LincolnLex44

*Consolidating discussion from #71, #66, #58, #31 to document the plan for implementing modifications to queries. This applies mainly to `SELECT` but also other queries.* **WIP: This issue will be...

shadowhand

Missing limit in mysql update queries

8

I'm getting this error: ``` Error: Call to undefined method Latitude\QueryBuilder\Query\UpdateQuery::limit() ``` and have noticed that limit capability is missing in Update queries. orderBy is missing too.

oscarotero

Improve identifier escaping

2

~The diff on this is larger than in actuality because `phpcbf` needs to be ran.~ Merging #162 will clear that up. I have a field with a backtick in a...

donatj

I'm going to open a second PR ( #163 ) - but the test suite (phpcs in particular) is currently failing. I'm going to build the second PR against this...

donatj

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start)...

dependabot[bot]

Greetings, Working on a new project and I'm running into this deprecation warning: ``` Deprecated: Latitude\QueryBuilder\QueryFactory::__construct(): Implicitly marking parameter $engine as nullable is deprecated, the explicit nullable type must be...

dashifen