The DB we use at work (SQLAnywhere) supports inserting from select, and using auto column name matching, so for a table with columns (name, en1, en2) you could have

    INSERT INTO tbl WITH AUTO NAME
    SELECT 'foo' AS name, 1 AS en1, 0 AS en2;

Not nearly as neat as the direct key=value syntax but...