If you are a experienced php developer with huge scale and complex project, you had a knowledge about how important "SQL Query" is.
Sometimes "SQL" solves the complex problem of service by easy way or it makes simple question to be big problem on your system,
so If you have big scale site,DBA must be the management of "SQL"
So, Here are queries made by XML for compatiblity. Have a look the database/queries/queries.xml
Below is configuration of query file in config/dev_config.php
// query xml file
$config['query_xml_file']=DATABASE_PATH."/queries/queries.xml";
<thuleframework> // query head tag
<thule> //query section tag
<query key='member'> select * from db_thule.tb_member where member_id='$member_id' </query>
</thule>
</thuleframework>
<thuleframework> // query head tag
<static_thule> // query section tag
<query key='member'> select * from db_thule.tb_member where member_id='?' </query>
</static_thule>
</thuleframework>
Query-section-tag is a section for many other parts of site just like blog,home,profile,etc.. and "member" is a key of query.
How to use query? go to Model chapter.
You can choose the fil-format in configure.ini
query_file_format = "sql" ; xml,sql
The format is very similar with the XML format and you will get used it easily.
[sample_thule]
thule = "select * from DB_THULE.tb_member where member_id='$member_id'"
thule_query1 = "select * from DB_THULE.tb_member where member_id='?'"
thule_query2 = "update db_thule.tb_member set register_date=now() "