Heuristics for showing a useful "next steps" message and link

[simonw]

If you perform a write like this one:

create view blah as select * from foo;

It would be nice to show a confirmation message like this:

View created: blah

This could be achieved for a bunch of common cases using really simple regular expressions.

[simonw]

Candidates for this feature:

• alter table ...
• create table ...
• create view ...
• drop table ...
• drop view ...

And maybe also these ones (harder to parse though):

• insert into ...
• update ...
• delete from ...
• create trigger ...
• create index ...
• drop index ...
• drop trigger ...

The drop ones won't show a next step link because the thing you would link to has just been dropped.

[simonw]

I'll ignore common table expressions.

[simonw]

I'll just do the create table/view x ones for the moment.