or you can create view for every table that supports soft deletion and ensure all of your read-only queries are using those table

    CREATE VIEW current_customers AS
        SELECT * FROM customers where deleted_at is null;

    SELECT * FROM current_customers JOIN ...

Of course, this comes with its downsides e.g. views need to be recreated in every migration and there might be some complex join operations that might not work.