Adjust tests for named parameters in SQL

Use named parameters in SQL queries

�� Automatic code style fixes

PHP code sniffer autofixes

Manual coding style fixes

Method and variable visibility, camel case method names. Some exclusions due to inheritance

Automatic coding style fixes

fix: stop OR filters causing problems

The filters coming from syntax should be grouped together in a subgroup
to that OR-filters cannot undo the filters on latest=1 etc.

Since we cannot know in the

fix: stop OR filters causing problems

The filters coming from syntax should be grouped together in a subgroup
to that OR-filters cannot undo the filters on latest=1 etc.

Since we cannot know in the filter function whether there is already a
subgroup for us to use or which to use, the solution was to give the
correct subgroup to the filter function directly.

Instead of adding another parameter to the already long list of
parameters for that function, I have chosen to give the
QueryBuilderWhere a reference back to the original QueryBuilder.

show more ...

use generated table alias in joins. fixes #246

For joining the multi table, we used the colref of the refrenced multi
column in creating the alias of the joined table. But when referencing
multi col

use generated table alias in joins. fixes #246

For joining the multi table, we used the colref of the refrenced multi
column in creating the alias of the joined table. But when referencing
multi columns from different schemas, the colref can be the same for two
columns. This patch now changes it to make use of the
generateTableAlias() method in our query builder, which makes sure all
aliases are unique.

show more ...

isset is not good for testing an array containing NULL

introduce getSelectStatement to modify selects later on

code style adjustment, no single line exceptions

use the query builder in Search

Tests still run through, so it seems to be correct so far

added group and sort by

fix and test placeholder replacement

tests for where

test that left joins are positioned correctly