naise_pos/db/query/purchase_order_detail.sql

-- name: CreatePurchaseOrderDetail :one
INSERT INTO purchase_order_detail (
  purchase_order_id,
  merchant_id,
  product_id,
  quantity,
  sub_total,
  product_price
) VALUES (
  $1, $2, $3, $4, $5, $6
)
RETURNING *;

-- name: GetPurchaseOrderDetailsByPuchaseOrderId :one
SELECT *
FROM purchase_order_detail
WHERE purchase_order_id = $1;