##### Basic queries

    '''Outputs a query to a temp table.

    For params, see run_query().

    '''

    else: # place rows in temp table

order_by_pkey = object() # tells mk_select() to order by the pkey

    '''For params, see mk_insert_select() and run_query_into()

    @param into Name of temp table to place RETURNING values in

    '''

    recover = kw_args.pop('recover', None)

    cacheable = kw_args.pop('cacheable', True)

    query, params = mk_insert_select(db, *args, **kw_args)

default = object() # tells insert() to use the default value for a column

        '''Inserts and capture output pkeys.'''

        cur = insert_select(db, out_table, mapping.keys(),

            *mk_select_(mapping.values()), returning=out_pkey,

        if row_ct_ref != None and cur.rowcount >= 0:

            row_ct_ref[0] += cur.rowcount

        add_row_num(db, out_pkeys) # for joining it with in_pkeys

        # Get input pkeys corresponding to rows in insert

        in_pkeys = temp_prefix+'_in_pkeys'

        add_row_num(db, in_pkeys) # for joining it with out_pkeys

        # Join together out_pkeys and in_pkeys

        run_query_into(db, *mk_select(db,

            [in_pkeys, (out_pkeys, {row_num_col: join_using})],

    # Do inserts and selects

    try: insert_()

        join_cols = util.dict_subset_right_join(mapping, e.cols)

        joins = in_joins + [(out_table, join_cols)]

        run_query_into(db, *mk_select(db, joins, pkeys_cols,

    return (pkeys, out_pkey)