in insert statements, how do you have database side calculated fields?

[ivankocienski]

so given

(sxql:insert-into :users (sxql:set= :name "user" :created_at "now()"))

produces the wrong sql

INSERT INTO users (name, created-at) VALUES ('user', 'now()')

when what i would like would be

INSERT INTO users (name, created-at) VALUES ('user', now() )

Many thanks!

[jackcarrozzo]

SXQL> 
(insert-into :users 
  (set= 
    :name "user" 
    :created_at '(:raw "now()")))
#<SXQL-STATEMENT: INSERT INTO users (name, created_at) VALUES ('user', (now()))>

[rudolph-miller]

SXQL> 
(insert-into :users 
  (set= 
    :name "user" 
    :created_at (:now)))
#<SXQL-STATEMENT: INSERT INTO users (name, created_at) VALUES ('user', NOW())>

[jackcarrozzo]

   ^
 / | \
   |

Thanks @rudolph-miller