How do I translate these SQL statements to SOQL?

How do I translate these SQL statements to SOQL?

q_opportunity varchar2(2000) := 'SELECT AMOUNT, C3G_TEAM__C,
COMMUTE_BONUS_AMOUNT__C, COMMUTE_MILES_ONE_WAY__C, ENGAGEMENTENDDATE__C,
ENGAGEMENTSTARTDATE__C, ID, INVOICE_COMMENTS__C, LEADSOURCE, NAME,
OWNERID, PRACTICEAREA__C, PRICEBOOK2ID, SOX_BONUS_AMOUNT__C,
SOX_BONUS_THRESHHOLD_DATE__C, STAGENAME, STP_BONUS_CONSULTANT_AMOUNT__C,
STP_BONUS_LEADER_AMOUNT__C, TYPE, WORK_TYPE__C, ACCOUNTID,
REFERRAL_CONSULTANT__C, CUSTOMER_REFERENCE_NUMBER__C, dummy__C FROM
OPPORTUNITY';
q_account varchar2(2000) := 'SELECT ACCOUNTSTATUS__C, ANNUAL_REVENUE__C,
ASSIGNED_TELEMARKETER__C, D_B_NUMBER__C, DBA__C, DLC_TERRITORY__C, FAX,
ID, INDUSTRY, NAME, OWNERID, PARENTID, PHONE, PHYSICAL_CITY__C,
PHYSICAL_COUNTRY__C, PHYSICAL_STATE__C, PHYSICAL_STREET__C,
PHYSICAL_ZIP_POSTAL_CODE__C, WEBSITE, DUMMY__c FROM ACCOUNT';
q_contact varchar2(2000) := 'SELECT CONSULTANT_REGION__C,
CONTACT_TYPE__C, CPA_ALUMNI__C, DEPARTMENT, EMAIL, FAX, FIRSTNAME,
GOES_BY_NICKNAME__C, HIRE_DATE__C, HIRE_MONTH__C, HOMEPHONE, ID,
LASTNAME, LEAD_SOURCE_DESCRIPTION__C, LEADSOURCE, MAILING_CITY__C,
MAILING_COUNTRY__C, MAILING_POSTAL_CODE__C, MAILING_STATE__C,
MAILING_STREET__C, MBAALUMNI__C, MOBILEPHONE, OTHERPHONE, PHONE,
REFERRAL_EMPLOYEE__C, REFERRED_BY__C, SALUTATION, SECONDARY_EMAIL__C,
SPOUSE_S_NAME__C, TERMINATION_DATE__C, TITLE, ACCOUNTID, DUMMY__c FROM
CONTACT';
q_opplineitem varchar2(2000) := 'SELECT ID, LISTPRICE, PRICEBOOKENTRYID,
PRODUCTID, QUANTITY, TOTALPRICE, UNITPRICE, OPPORTUNITYID,
NEW_BILL_RATE_EFFECTIV_DATE__C FROM OPPORTUNITYLINEITEM';
q_oppcontrole varchar2(2000) := 'SELECT CONTACTID, ISPRIMARY,
OPPORTUNITYID, ROLE FROM OPPORTUNITYCONTACTROLE';
q_pricebookentry varchar2(2000) := 'SELECT ID, NAME, PRICEBOOK2ID,
PRODUCT2ID, PRODUCTCODE FROM PRICEBOOKENTRY';
q_product2 varchar2(2000) := 'SELECT ID, NAME, TERMINATION_DATE__C,
CONSULTANT_REGION__C, EMPNUMBER__C, DUMMY__C FROM PRODUCT2';
q_pricebook2 varchar2(200) := 'SELECT ID, NAME FROM PRICEBOOK2';
q_user varchar2(2000) := 'SELECT Country, Department, Division, Email,
EmployeeNumber, Fax, FirstName, Id, LastName, MobilePhone, PostalCode,
State, Title, Alias, City, CompanyName, Phone FROM USER';