Now I'm looking for a method for generating forms.
formkit looks quite good, although not that simple.
I'm one of the authors of FormKit.
The apparent complexity is largely due to the crappiness of HTML, but
we've done a pretty good job (IMHO) of putting a consistent api across
all field types. most of the complexity is under the hood and out of
your hair... again, IMO.
It would be pretty easy to do what you ask -- to make SQLObjects and
FormKit fields more intimately hooked together. You could write a
simple Validator/Convertor that would inspect your database objects to
determine what's required.
Ultimately, there is no free lunch however, eventually you will find an
example of something you need that is not easily "automated" by such a
hack... again, HTML (and especially forms) SUCK. Sooner or later you'll
have a database object that's too complicated for 'smart' code, and
will have to break your own rules...
Ian's approach with FormEncode might be more to your liking... stop
trying to mess with HTML and start worrying just about values.
If you have any specific FK questions, let me know.