I usually assume a basic understanding of SQL.

I'm not going to put a comment like "and now we insert the data into the dimension".

I explain the business logic used in the queries, why I do certain things and I explain the more complex SQL, such as for example using FOR XML PATH to concatenate queries.