(a) All moneys received as pension from the state or a political subdivision as defined in § 4-58-102, before receipt, or while in the recipient's hands or upon deposit in the bank, shall be exempt from execution, attachment or garnishment other than an order for assignment of support issued under § 36-5-501 or a qualified domestic relations order as provided in subsection (c), whether such pensioner is the head of a family or not.

(b) Except as provided in subsection (c), any funds or other assets payable to a participant or beneficiary from, or any interest of any participant or beneficiary in, a retirement plan which is qualified under §§ 401(a), 403(a), 403(b), 408 and 408A, or an Archer medical savings account qualified under § 220 or a health savings account qualified under § 223 of the Internal Revenue Code of 1986, as amended, are exempt from any and all claims of creditors of the participant or beneficiary, except the state. All records of the debtor concerning such plan and of the plan concerning the debtor's participation in the plan, or interest in the plan, are exempt from the subpoena process.

(c) Any plan or arrangement described in subsection (b), is not exempt from the claims of an alternate payee under a qualified domestic relations order. However, the interest of any and all alternate payees under a qualified domestic relations order are exempt from any and all claims of any creditor, other than the state. As used in this subsection (c), “alternate payee” and “qualified domestic relations order” have the meaning ascribed to them in § 414(p) of the Internal Revenue Code of 1986, as amended. Notwithstanding this subsection (c) to the contrary, an optional retirement program established pursuant to title 8, chapter 25, part 2 shall honor claims under a qualified domestic relations order that complies with § 8-25-210.