DDC-999: DQL always needs a FROM clause, should be changed #5534

Closed
doctrinebot opened this Issue Jan 23, 2011 · 1 comment

2 participants

@doctrinebot

Jira issue originally created by user felicitus:

Sometimes a developer needs to issue a query without a FROM clause. This especially occurs using the QueryBuilder, when you may or may not have a table to select from, but call a stored procedure always.

Example:

$query = $em>createQuery('SELECT (1<ins>1)');

The above query fails because the lexer expects T_FROM. If you replace (11) with a stored procedure, this example makes more sense.

One might argue about that you should use DBAL directly, but I disagree, because it always can happen that you end up in a situation like this:

$qb = $em->createQueryBuilder();

$qb->select("SOMEFANCYPROCEDURE()");

if ($condition) {
  $qb = $qb->from("additionalTable t");
}
@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@beberlei
Doctrine member

This is not a supported use-case for DQL.

@beberlei beberlei closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment