-- name: CreateSaleOrder :one
INSERT INTO sale_order (
  merchant_id, 
  customer_id,
  code,
  created_by,
  is_paid,
  total,
  paid_nominal,
  note,
  change,
  is_keep
) VALUES (
  $1, $2, $3, $4, $5, $6, $7, $8, $9, $10
)
RETURNING *;