Full table scan instead of filter

Review this Python data-access function that returns recent active orders for one customer. The orders table has tens of millions of rows.