Do you write SQL queries yourself? Up to what level — simple SELECT with JOIN or window functions, aggregations, subqueries?

I write SQL queries at various levels of complexity depending on the task. Usually, these are not only simple SELECTs with JOINs but also more advanced constructs — window functions for analytics, aggregation for summary data, subqueries for nested logic. For example, window functions allow calculating rankings or moving sums without grouping the entire result, which is convenient for reports and analytics.