How can we help you today? How can we help you today?

Derived tables?

The biggest gap in the previous versions of SQL Prompt, in my opinion, was support for derived tables. Any plans to add support to this version? I use a lot of derived tables, CTEs, and the like -- virtually every query I write of any non-trivial level of complexity uses one or more of these constructs, so for this product to be very useful to me it's essential that it support them...

Currently, it is just giving me garbage when I try to use it on a derived table or CTE. For instance, type in:

select
from
(
select id1
from x
) y
WHERE y.

As soon as I hit the "." after the "y", I get a popup window, as expected. First option: acud (ALTER CUBE) -- not at all within the context of where I am in the query (the first choices, even if not from the derived table, should at least be column names), and not even in the right language.
amachanic
0

Comments

1 comment

Sort by
  • Lionel
    We are working hard on adding support for constructs like derived tables. In this new version of SQL Prompt we are using a new parser which should allow us to support these statments. I can't promise anything but I personally would like to see better support for these statments as I use them all of the time. They are the best thing sinced sliced bread.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.