>
> before I start thinking about writing something that does this, is
> anyone
> aware of one that already exists.
>
> I want to do "select a,b from mytable where c < 97" and have the output
> as
> insert statements, automatically, on unix (fedora 8 to be precise)
>

I think fbexport can do that.
http://fbexport.sourceforge.net/

Sasha