What is the syntax for using a user token in an insert statement. The following doesn't work.

<SubmitCommand CommandText="INSERT INTO [goal_tracker] ([title], [description], [type], [targetDate], [isAchieved], [userId]) VALUES(@title, @description, @type, @targetDate, @isAchieved, [[User:ID]]) " />


Use the SubmitCommand's (or SelectCommand's) child tag: <Parameter> and set the value of the parameter to your token:

<SubmitCommand CommandText="INSERT INTO [goal_tracker] ([title], [description], [type], [targetDate], [isAchieved], [userId]) VALUES(@title, @description, @type, @targetDate, @isAchieved, @UserId) " >
<Parameter Name="UserId" Value='[[User:ID]]' />
</SubmitCommand>