[Flamerobin-devel] Default SQL for "Browse data" command

[Milan B. <mil...@gm...>]

Hi,

In earlier version when you "select from..." a table, it would display
table data using a select with each column prefixed with an alias
like:

select a.col1, a.col2, a.col3
from table1 a

Now the command is called "browse data" and aliases are no longer
there. This makes me mad and here's why... I rarely "just" browse
data. The generated select is a base for extending with stuff like
"JOIN ..." or "where exists ()", etc. Not having aliases is not
user-friendly because:

1. when you join with another table you can get many ambiguous fields.
You have to add alias manually to each column which is a major PITA.

2. without aliases autocomplete for column names does not work

Now, you could argue that I could use "generate code"->"select
from..." but that:

1. a couple more clicks (open submenu, (de)select columns in dialog,
click a button)
2. many time I don't know that I would need to edit SQL beforehand. I
"browse data" looking for something and only then I get the idea to
edit the SELECT statement.

</rant>

Now, does anyone have something against reverting to old behavior,
i.e. with alias prefixed to each column?

-- 
Milan Babuskov
http://www.guacosoft.com