Crank SQL

[Mike Kerner]

Something else that would be cool for valentina to do is to generate the
SQL that I would need to make something happen so that I can embed it in
whatever app I'm developing.

For example, let's say I want to change the datatype of a column in sqlite.
You can't really do that, but Valentina works around it.  When I want to
make that happen in my app, I have to crank the SQL.  Generally I do that
by telling Valentina to create an SQL dump of before and after (so I can
create the temporary table, then copy the data, then drop the original
table, then recreate it, then copy the data back).  If Valentina wrote the
SQL for me...

I can come up with a variety of other examples where it would be nice to be
able to walk Valentina through a sequence of operations, and have it give
me the SQL to copy/paste.

-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20141022/2497be82/attachment.html>