Select all or part of a table, possibly with new columns

Below, square brackets mark optional elements.

select [L_exp] [p_s] [by p_b] from t_exp [where p_w]